Forum Discussion
consecutive Export Rest API "Request is blocked by the upstream service until" ... Export Rest API
Each API has its own limitation of number of requests that can be processes in each time window.
For "Export to File" API the limitation also depends on the type of the reports you are exporting (Power BI reports / Paginated reports) and the type of the capacity the report resides in (Premium Per User, Premium Per Capacity)
I have added a Delay for 5 minutes in the for each loop and thaat doesnt seem to have helped either
Im trying to find a solution for this myself. I dont understand how a 5 minute delay hasnt helped this problem?
depending on your licence/contract you may be limited to 8 exports per 24 hrs. A 5 minute delay does nothing in such a case.
My account have Power BI Premium per user license. It should allow 48 refreshes/day.
I have a power automate flow to refresh the dataset using Power BI API. It failed after 6 attemps and got "Request is blocked by the upstream service" error.
It is weird.
This may be a limit on the data source, not on Power BI.
Thanks for your information.
The datasource we are using is Azure Data Lake Storage. Do you know what is the limit?
After some tests, I found when Power BI API is blocked, I can still goto the Dataset in Power BI service and refresh it manually.