Forum Discussion
After handling API paging, auto refresh not possible on powerBI cloud
Hi folks, I handled the API pagination in my power query code using : listOfPages = List.Generate(
() => getNextPage(null), // get the first page of data
(last...
jennratten
Super User
Super UserThanks for the extra info. This is a pretty common challenge and there are a lot of posts that explain how to bypass it. I have included some links below that should help you.
https://forum.enterprisedna.co/t/best-practice-to-get-data-from-rest-api-that-requires-paging/11388
https://datachant.com/2016/06/27/cursor-based-pagination-power-query/