Unanswered

Concurrency limit for the Export To File API

(0) Share

Report

Posted on by Hyldog

Hi
I have a flow where I export to file for Power BI within a apply to each action but I get an error:
"You have exceeded the concurrency limit for the Export To File API. Consider reducing the number of concurrent pages being exported. Consider reducing the number of concurrent pages being exported."

I have set the concurrency control to 50 for the Apply to each 2 step. Besides this flow I run a concurrent flow but my question is why it fails and not just postpone the action when the capacity is maxed out?

The issue

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report

Hello @Hyldog ,

I'd guess it's a security measure from Microsoft side to protect their APIs - if they just postponed everyone's requests once they reach their limit they could have a very long queue waiting to be processed that could make the API unavailable for other users.

Was this reply helpful? Yes No
Hyldog 7 on at

Like (0)

Report

Hi @tom_riha

Good guess but I only have 70-something executions and the limit for concurrent executions is 50 so how come it not execute 50 and then 20. So should I make my flow more efficient or do you know how to handle this most effectively?

Cheers,
Mikkel

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @Hyldog ,

it's not related to the limit in the Power Automate flow, based on the error message it's related to the Power BI API. It just can't handle so many requests at the same time. You might try to decrease the concurrency in the loop to give the Power BI API a break, or try to disable it completely.

Was this reply helpful? Yes No
Hyldog 7 on at

Like (0)

Report

okay thanks for the elaboration, @tom_riha

I will look into ways to decrease the loop as the flow has to run each week.

Was this reply helpful? Yes No