Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
Need to call power bi rest api to generate multiple pdfs and save them to blob.
I run the program in my pc with logic :
Run a local file
for each row of the file
call power bi rest api to generate pdf based on row content (i.e. "ExportTo" rest api)
wait unitil pdf is ready (i.e. call rest api to check status)
download pdf generated and move it to blob.
After first pdf genreted success,the second call "rest api export" always get "Request is blocked by the upstream service until,,,,"
After rerun, the first call may get "Request is blocked by the upstream service until,,,".
Only "ExportTo" rest api has this problem, others like "reports" or "groups" rest api do not have this problem.
Already struggle for a few days, any suggestion?
Solved! Go to Solution.
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?
Actually this does work for me. A 5 mins delay within the loop seems to have helped
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.
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)
That is a forced restriction based on your license level. Find alternatives.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.