topic Re: consecutive Export Rest API "Request is blocked by the upstream service until" ... Exp in Developer

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

kenwat — Fri, 17 Feb 2023 14:40:29 GMT

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?

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

lbendlin — Sun, 19 Feb 2023 02:08:47 GMT

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

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

AmosHersch — Sun, 19 Feb 2023 12:26:51 GMT

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)

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

DebbieE — Tue, 28 Mar 2023 15:26:55 GMT

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?

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

lbendlin — Tue, 28 Mar 2023 15:56:49 GMT

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.

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

DebbieE — Tue, 04 Apr 2023 11:15:11 GMT

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

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

Azure_newbie — Tue, 19 Sep 2023 09:35:38 GMT

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.

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

lbendlin — Tue, 19 Sep 2023 10:47:00 GMT

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

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

Azure_newbie — Tue, 19 Sep 2023 12:03:35 GMT

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.