Forum Discussion
Thilbetr
4 years agoFrequent Visitor
Paginated, Throttled, Parameterized API Data Sourcing
Good afternoon, Pooling our awesome community here for thoughts on approach. I am currently sourcing data from an API endpoint using Power Query on PowerBI Desktop. The API isn't the most ide...
Anonymous
4 years agoNot applicable
Hi Thilbetr - you need to use a List.Generate function in the API function to check for Nulls on the final page. Try the following post as an example: How not to miss the last page when paging with Power BI and Power Query (thebiccountant.com)