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!
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:
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.
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!
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.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020