Forum Discussion
consecutive Export Rest API "Request is blocked by the upstream service until" ... Export Rest API
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?
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)
8 Replies
That is a forced restriction based on your license level. Find alternatives.
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.
Actually this does work for me. A 5 mins delay within the loop seems to have helped
