Forum Discussion

kenwat's avatar
kenwat
Regular Visitor
3 years ago
Solved

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 r...
Need Help
  • AmosHersch's avatar
    AmosHersch
    3 years ago

    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)

DebbieE's avatar
DebbieE
Community Champion
3 years ago

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?

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        lbendlin
        Super User
        2 years ago

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

  • DebbieE's avatar
    DebbieE
    Community Champion
    3 years ago

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