Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

PowerApps loading Azure SQL data hangs/slow

From time to time, loading data from Azure SQL in our apps hangs or extremely slow. (The "above dots" keep running forever). But seems like after 10-15 mins or so, after reopen the app the speed would come back to normal. We found out that if we create another exactly same connection but with different name, when everytime the app hangs, we ask our users to switch to the second connection, and the app can run correctly. They have to do this like below:






This issue constantly occurs, so our users have to switch the connection all the time which we got a lot of complains. Not quire sure what caused the hangs/slow, it looks like to me the session/tread got stuck for some reason, and then got killed by times out after a period of time, and then the connection can be used again...


I dont know if there is something wrong that we did in the app like we need to close the connection somewhere or....The session ID is: 13c72e33-9469-4f12-99ae-54203e88b3e9


Has anyone had the similar issues? Any help would be highly appreciated.


Community Support
Community Support

Hi @michaelWu,


Please take a look at the following blog:

Performance considerations with PowerApps


Follow the advices (Optimization) mentioned in the blog above, if issue still insists, please consider generate a Fiddler trace for further analyze.




Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I've read this article before. It was great but I think this time there is something wrong with connection to Azure DB. At least there are 2 more posts that report the same thing:


I think Powerapps team need to check the connection with Azure DB if so many people have the same issue. Thanks.

A year later, this is a real problem.  A post above recommends "follow the advices(sic)" of an extremely lengthy and difficult to understand article, written to an audience of presumably non-programmers, since that is who PowerApps is marketted toward.  Is this an attempt to shut people up reporting the problem?  The fact of the matter is, a query should take less than 1 second is now taking 15 minutes to load!  This is not an optimization issue, but a serious error in the system!!

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (5,410)