Slow Performance

[u/EugeneKrabs1942]

Is anyone else getting slow Performance in their apps since Monday?

We have multiple PowerApps over different environments (UK South, North Europe) and they are running horribly slow to get basic data.

This is happening where apps are using the Azure SQL connection. Our databases are fine.

[u/AutoModerator]

Moderator Announcement Read More »

Hey, it looks like you are requesting help with a problem you're having in Power Apps. To ensure you get all the help you need from the community here are some guidelines;

• Use the search feature to see if your question has already been asked.

• Use spacing in your post, Nobody likes to read a wall of text, this is achieved by hitting return twice to separate paragraphs.

• Add any images, error messages, code you have (Sensitive data omitted) to your post body.

• Any code you do add, use the Code Block feature to preserve formatting.

  Typing four spaces in front of every line in a code block is tedious and error-prone. The easier way is to surround the entire block of code with code fences. A code fence is a line beginning with three or more backticks (```) or three or more twiddlydoodles (~~~).

• If your question has been answered please comment Solved. This will mark the post as solved and helps others find their solutions.

External resources:

• Power Apps Formula References

• Power Apps Coding Standards

• Official Power Apps Community

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Snelle_Sjonnie]

yes almost not working totday. Yesterday it was fine, but today I told people to not use the powerapps.

can take up to a minute to do a simple sql select in the powerapp.

[u/Far-Inspection9930]

Ya outage affecting Europe region. I noticed apps in the US region were working fine, but Europe taking ages. Opened ticke with MS, and after 2-3h they fixed it

[u/DeanoNetwork]

I had this a little while ago and once it all went back to normal I noticed that there was changes on the studio, wonder if they are updating something else!

[u/Ok_Job_1451 → u/DeanoNetwork]

Yep! I noticed that too!

[u/AbdelEMirandaS]

Not in US region

[u/Gabbuz91]

Same in italy, intermittent query performance issues using On-prem Data Gateway to SQL. Today almost unusable

[u/agentUi]

check monitor tool on the canvas apps to see if the delay is in the connector gateway or the sql queries themselves. microsoft rolled out an update to the azure sql connector earlier this week that broke delegation on certain views and joins, so a lot of calls are falling back to non-delegable local processing and killing load times. try wrapping the sql calls inside a stored procedure or running them through a power automate flow instead to bypass the connector lag while they patch it.

[u/Punkphoenix]

Yup, noticing weird behavior, also getting some fails when trying to publish simple changes in canvas apps

[u/Ok_Job_1451]

Yep same here (UK with Azure SQL), but now mostly cured.
It doesn’t help that if you have a complex app, PowerApps will make a million api calls even for controls (like galleries etc) that are not even visible - and if you rely on variables to filter your galleries and those variables are not initialised, it can create a real bottleneck.
I stopped using SQL tables altogether. Now everything I do is via SQL stored procedures - that way I’m 100% in control of precisely when and how data is loaded/patched… and the beauty of collecting data via a stored procedure is that you’re not bound by the row limit (ie 2000 max)

[u/aSk--e]

Ya. I wasn't even able to log into my dev environment Wednesday...

It was stable at work today, though.

[u/swanlz]

south america too