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
(lastPage) => lastPage <> null, // stop when the function returns null
(lastPage) => getNextPage(lastPage) // pass the previous page to the next function call
),
The problem is when I deploy my dashboard, I cannot schedule the auto refresh.
Do you know how to fix that ?
Regards,
3 Replies
- jennratten
Super User
Please provide more information. Are you publishing the pbix and then not seeing an option to set a refresh schedule? When you manually refresh the report is the refresh successful? If not, what error message is received?
- ochaouiFrequent Visitor
When I publish it, I obtain this in the refresh section :
Have you ever succeeded to have a paged API refreshed ?
- jennratten
Super User
Thanks 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/