Unanswered

Azure SQL requests limit reached

(0) Share

Report

Posted on by WPB

204

What am I supposed to do with this? I'm just developing the app. There will be dozens of users of this at a time... Even if I upgrade the server to 10 times the amount I'm paying at the moment, it will only get me 50% more requests... I think the problem is that too many connections are opened to the server and never closed. Is there anything I can do to close them in PowerApps? Thanks for your time!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WPB,

How many Azure SQL Server connections do you create within your PowerApps?

Based on the error message that you provided, it seems to tell that you have reached a limit of concurrent logins allowed for that database on that service tier.

The limit of concurrent logins allowed for Azure SQL Database is based on the service tier your Azure SQL database belongs to.

More details about the limit of concurrent logins allowed for Azure SQL database, please check the following blog:

https://blogs.technet.microsoft.com/latam/2015/06/01/how-to-deal-with-the-limits-of-azure-sql-database-maximum-logins/

If you want to close the concurrent logins for Azure SQL Database within PowerApps, I afraid that there is no way to achieve your needs in PowerApps currently.

Best regards,

Kris

Was this reply helpful? Yes No
WPB 204 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Kris!
Right now, I have 4 connections to the same Azure server for the 4 Databases inside. I use about 80 of the tables (Data sources). I have an S0 tier (60 concurrent connections) but the thing is, I'm the only one using the app. How can 200 people use it if I get this limitation when I'm the only one using it? I really need a tip on that... Not the first time I get this error and I'm concerned that my project won't work due to this...

Sorry for the delay, had big meetings last week 🙂

Thanks a lot for the help!

Was this reply helpful? Yes No
WPB 204 on at

Like
a
(1)

Report
Copy link

Link copied!

@v-xida-msft
This is a recurring issue. I really need a solution. I'm preparing to deploy many apps to the whole company (± 200 people) and I feel like it's gonna be a big issue.

PS: The problem is with power apps since I'm the only use for these apps to this date.

Was this reply helpful? Yes No