Web API Pagination with List.Numbers not working in service with

[gwilliams]

I have created a report that uses a web api that has multiple pages. So, I used the following tutorial on getting the additional pages:

How to do Pagination on a REST API in Power Query (Part 1) 

Scenarios:

Power BI Desktop - it works and can return all of the data.

Power BI Service - When I publish I the following error:

Publishing is complete. However, we couldn't refresh your dataset.  Please manually refresh your dataset in the service or schedule refresh.  When you go to schedule refresh or dataset settings you get: "You can't schedule refresh for this dataset because the following data sources currently don't support refresh. Data source for Query1 Discover Data Sources (link).   

I only get this when I start using the List.Numbers method to retrieve the additional pages and then get the json.document() portion of the Advanced Editor to use in a new column to get the additional pages.  

I have tried changing hte data source settings, by edit permissions to no avail  the data uses an x-api-key and a authorization header to authenticate so I am using anonymous for the credentials.  

My question is why does it work in desktop and not in service. And how do I get it to work in service?

[v-cazheng-msft · Accepted solution]

Hi @gwilliams,

It’s by design that most dynamic data sources cannot be refreshed in Power BI service. To determine whether your dynamic data source can be refreshed, open the Data Source Settings in Power BI Desktop, and then select the Web API data source. Then, you will see a warning message like the following screenshot which means such kind of data source can’t be refreshed in Power BI service.

But there are exceptions exist, you could edit your query per the description.

For more details, you could refer to Data refresh in Power BI - Power BI | Microsoft Docs.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know how your tables look like, the relationships you create for them and how you create these two count measures. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[wsdcawefwqrevfq]

I do not have that warning when selecting the Power Bi REST API datasource.

Has anyone suicessfully scheduled a refresh when referencing thge REST API?

I am using the Datasource: https://github.com/migueesc123/PowerBIRESTAPI

[gwilliams]

Also this is most slowest and board I have ever posted on today!!!