Forum Discussion
Anonymous
3 years agoNot applicable
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? Thank you!
Find attached my Power BI API call code for a specific table (clicks).
Regards,
David