API Call 1,000 rows limit Power BI Desktop

[Anonymous]

Hi.

I am calling an API (the smarP API) with Power BI Desktop. For each table it only returns 1,000 results per call, as they say in the smarP API documentation. I would like to know how to keep making API calls to get all the results from all the tables and not just 1,000.

I have seen in the smarP API documentation that there is a way to do it with 'next' parameter, but I don't know how to put it in Power BI. Do you know how can I get all the rows for all the tables?

Find attached my Power BI API call code for a specific table (clicks).

Thank you!

Regards,

David

 

 

[lbendlin · Accepted solution]

Handling paging for Power Query connectors - Power Query | Microsoft Learn