'Web API Pagination using List.Numbers Works in PowerBI Desktop but not in PowerBI Service
I have a PowerBI report that uses both a Web URL and SQL Server data. The Web URL only returns 100 rows per page, so I followed this tutorial to loop through the pages to retrieve all of the data.
How to do Pagination on a REST API in Power Query (Part 1)
I am using the List.Numbers method from that video. Everything works fine in PowerBI Desktop on my workstation. However, when I publish to PowerBI Service I get the following message: PowerBI Publishing Warning "Publishing is complete. However, we couldn't refersh your dataset. Please manually refresh your dataset in the service or schedule refresh."
When I go to PBI service to the dataset it shows this: enter image description here
Has anyone else experienced this issue? How did you work around it?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|