Does anybody know whether there has been a recent update to PowerApps that may have affected end-user performance when connecting to SQL servers?
Our apps have been working fine, up until yesterday, where now they are very unresponsive and slow to populate where we are calling upon SQL data. We haven't made any changes to our SQL servers and the servers are operating fine as normal, so just want to rule out any potential issues on the PowerApps side?
Hi @jhanley ,
Do you mean that the app connected with Sql Server become slower?
I've made a similar test but not met the same problem like your description.
My app works as normal.
Recently, I haven't received any report about updating SQL server.
So I think that should not be updating's issue.
Maybe you need to consider improving your app.
Many reasons why lead the app working slowly.
Here's a doc about some tips of improving app performance:
What's more, making your network in a good condition is also very important.
Hi @v-yutliu-msft ,
Thanks for confirming that there hasn't been any updates that may have pushed this out of sync.
It was interesting as users suddenly started to report that the app was significantly slower despite this working fine for a week or so after it's initial publish. We did implement a PDF viewer within the most recent version, so am wondering if this has caused issues as it is noted that this pulls through a large execution script which may be affecting our performance. We will look to update the app to exclude this feature to see if this helps.
Do you know if tables, queries and flows count as a 'data source', or does this refer specifically to the server that they are stored in? The article mentions to keep this below 30, but we have 62 connections into one server.
Many thanks for your help,
I have exactly the same experience since yesterday with Azure SQL.
Additionally we have also latency issues with Flow, but not shure this is connected to this problem.
I have republised the app but it doesn't help.
Coud anybody from MS check this isse?
The App ID is: 0afe07b9-691a-4b08-8199-efd035a3a072
@jhanleyA couple of things:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for the next call on June 15, 2022 at 8am PDT.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.