Forum Discussion
Please help - Refresh of dataflow connected to Web API takes forever
Hi all,
I am trying to refresh a Power Bi dataflow connected to Web API containing one single query (no transformations, only expanding a few lists and records) but it takes forever so after 1 hour I canceled the refresh. When I connect to the endpoint with my browser or Postman, the data are loaded immediately, but the dataflow clearly has an issue with it. Even when I reduce the import to 1000 rows the refresh will not complete. What is causing this, any ideas?
The data provider says he ensures cache information is available on-demand - not sure what this means for Power BI, but it looks like it can't access this cache. Any thoughts?
Postman likely only fetches a small subset.
You can check the network trace when you run the query on the dataflow editor. See if you spot any 429s or other delay tactics.
1 Reply
- lbendlin
Super User
Postman likely only fetches a small subset.
You can check the network trace when you run the query on the dataflow editor. See if you spot any 429s or other delay tactics.