cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Slowness With Connection To SQL Server

Has anyone else had issues of periodic EXTREME slowness when doing database calls to a SQL Server hosted in Azure?

 

This seems to happen on and off where the database calls just start to take about 20x as long as normal and then it will magically resolve itself.

 

Our database admin has checked the server load during these times and there's nothing exceptional showing that should slow it down this much. 

 

I am trying to figure out if this is an issue on our end or PowerApps. Nothing has changed within the app itself as far as how the data is being pulled that should effect the load times, but yet this intermittent problem occurs and almost renders the app unusuable.

 

Any thoughts or ideas would be greatly appreciated.

 

 

29 REPLIES 29
michaelWu
Helper I
Helper I

Exactly same here! Powerapps team, please do something! Our users complains a lot about this. 

Any news about the issue? I'm having a very hard time with my users.

jcooper123
Regular Visitor

All of my apps now don't even connect. Something changed within the last few hours that has taken many production apps down and out. 

 

The server returned an HTTP error with code 0. An error has occurred on the server. I also can't create any new connections to Azure SQL databases.

 

I am having the exact same issue.  random slowness that does not correspond to the DTU allotment that we have with Azure.  And as of right now, the App is reporting a server error and cannot connect, but Azure is not reporting any issues.  

It seems that all of PowerApps has sh*t the bed.  Nothing is working or connecting.  Flow is also jacked up right now.  Must be a serious situation.

mayuro
Microsoft
Microsoft

We are investigating
GCS
Regular Visitor

Please add us to the broken list - 75% failure to fetch Sharepoint info in both Powerapps and Flows for 2 hours. (unusable)

 

No problems other than occassional but livable slowdowns before today.

Just want to chime in that it appears to be somewhat wide-spread.

All apps are down here now...it's good we did the demo/presentation this mornign to a user group...

Seems like working now...

This keeps happening to us. Its almost every week powerapps stops working with SQL server. I'm seriously considering abandoning all of the hard work we put into powerapps for a different platform. 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,325)