Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

API Call 1,000 rows limit Power BI Desktop

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