Cliengo no tiene una integración nativa para PowerBI, y su servidor API Rest lógicamente devuelve un json.
El mismo tiene paginación de 50 resultados por página.
Es necesario desarrollar un script básico para traer la tabla de resultados completa, recorriendo todos los registros disponibles a través de la paginación utilizando offset + limit.
Greetings!
I have read your description carefully and understand what you actually need.
I am an experienced developer and can handle this project easily and in perfect manners.
I am available now and can start right away, I will develop it in the least time.
I am an experienced and professional developer so everything will be well managed.
I assure you the work will be provided with quality.
Waiting for your response, feel free to get in touch.
Thanks!