consecutive Export Rest API "Request is blocked by the upstream service until" ... Export Rest API

[kenwat]

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?

[DebbieE]

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?

[DebbieE]

Actually this does work for me. A 5 mins delay within the loop seems to have helped

[lbendlin]

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.

[Azure_newbie]

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.

[lbendlin]

This may be a limit on the data source, not on Power BI.

[Azure_newbie]

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.

[AmosHersch · Accepted 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)

[lbendlin]

That is a forced restriction based on your license level.  Find alternatives.