After handling API paging, auto refresh not possible on powerBI cloud

[ochaoui]

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,

[jennratten]

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://community.powerbi.com/t5/Power-Query/Dynamic-data-sources-aren-t-refreshed-in-the-Power-BI-s... 

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/ 

https://docs.microsoft.com/en-us/power-query/handlingpaging 

https://www.youtube.com/watch?v=g5bo_UAQjIE 

[jennratten]

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?

[ochaoui]

When I publish it, I obtain this in the refresh section :

Have you ever succeeded to have a paged API refreshed ?