cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
craigblowfield
Frequent Visitor

SQL connector throttling limits

Can anyone clear up the throttling limits of the SQL Server (to Azure SQL) connector within a Power Apps context.
 
There are 2 mentioned scenarios in the docs:
  • Power AppsShared EnvironmentAllAPI calls per user30030
     
  • API calls per connection10010 seconds

     

    I really hope its the first with regard to basic querying (Filter, Patch etc) of tables as the second really isn't very scalable for a large multi user application.

2 REPLIES 2
yuxi666
Microsoft
Microsoft

Hi @craigblowfield 

 

The SQL API Call is actually limited to per connection rather than per user. If you have 100 people, all of them use same SQL Connection, in 10 seconds, each of them could send a SQL API Request.

 

Best Regards.

yuxi

 

 

Thank you very much for your response.

 

In that case, when is the special throttling limits applicable as described below

 

Power Apps - Shared Environment - All API calls per user 300 30

 

I feel that 100 calls across all users for a single connect not very scalable, especially for a high user solution.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

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