Forum Discussion

gwilliams's avatar
gwilliams
Frequent Visitor
4 years ago
Solved

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

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)   ...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    4 years ago

    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

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago

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