Answered

Got the error due to Throttling Limits

(0) Share

Report

Posted on by Daewoo

We've got the following error during connection to MS Excel via Power Automate.
{"statusCode": 429,"message": "Rate limit is exceeded. Try again in 4 seconds."}

Then we found it's occurred due to the following limit.
https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/#limits

So I'd like to know how to resolve it. We'll try to separate the connector for each flow.
And any others?
Will the restrictions be relaxed by purchasing a paid license?

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Daewoo

Yes, the easiest solution may be creating different connections for each Excel action.

Additionally if this is due to running many Excel Create Update or Delete actions (like 100+) in a loop, then you can set up the flow to use batch actions. It does take a little more set-up:

Excel Batch Update & Create: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706

Excel Batch Delete: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Delete/m-p/1634375#M735

Was this reply helpful? Yes No
Daewoo 6 on at

Like (0)

Report
Copy link

Link copied!

@takolota
Thank you for your response and information.
It's useful for us.
How about the following question? Let me know if you know.
> Will the restrictions be relaxed by purchasing a paid license?

Was this reply helpful? Yes No
Verified answer

takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Daewoo

I’ve never seen anything that mentioned different throttle limits for different licenses, only higher priority/speed. So I guess you might get higher priority among the throttled flows that way? But I wouldn’t take that as a great solution unless you’re running everything out of that one account & just want the extra insurance of a premium license on that account.

Was this reply helpful? Yes No
Daewoo 6 on at

Like (0)

Report
Copy link

Link copied!

@takolota
Thank you and yes, it's just last option if we cannot resolve by other solutions or it's easiest one.
I got it.

Was this reply helpful? Yes No