cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MangoMan09
Helper II
Helper II

How do SQL API call limits work?

Hi PowerApps Community,

 

One of the Apps I'm developing seems to be hitting the SQL's API call limit. While there are some improvements that we can apply on the App's code I was curious if the sheer amount of users could be impacting the app


On the documentation page ( https://docs.microsoft.com/en-us/connectors/sql/ ) it says on a Canvas App level the Calls available are 300 calls every 30s per user

Does this ,per user, mean different accounts using the same connection?
For example:

If there's a SQL connection called "Connection 1", and user A does 305 calls in 25 seconds and user B does 125 in 45 seconds.

Does this mean that only user A will be throttled? or will the throttle apply to Connection 1?

On top of that, how are these Calls balanced between PowerApps and Power Automate, If Power Automate reaches a cap does it impact the PowerApps and vice-versa?

1 REPLY 1
eka24
Super User
Super User

The calls is per connector. More information on this post;

https://powerusers.microsoft.com/t5/Building-Power-Apps/What-is-the-SQL-Limit-for-API-calls/m-p/3902...

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,019)