cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Rate Limit Exceeded - SQL On Premesis

This is starting to get a joke now.

Patching SQL on Premesis from powerapps and at about 200 records in.. Rate Limit exceeded!

 

Business software..  Not Personal software MS.

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Rate Limit Exceeded - SQL On Premesis

Hi @Delid4ve

The "Rate Limit exceeded" error means that you hit the limit of API calls for the SQL Server connector.

There is a limit in the API calls for the SQL Server connector -- 800 calls per 10 seconds. More details about the API Calls limit for connectors in PowerApps/Flow, please check the following article:

https://veenstra.me.uk/2018/07/17/microsoft-flow-connector-limits/

In order to fix this issue, please consider take a try to reduce the API calls from your app to the SQL Server connector.

On your side, you should patch less records (e.g. 50 records) to your SQL table once time, and then patch the next 50 records, etc.

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.