SQL connector throttling limits

[craigblowfield]

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 Apps

  Shared Environment

  All

  API calls per user

  300

  30

• API calls per connection

  100

  10 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.

[yuxi666]

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

[craigblowfield]

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.