Powerapps connection to Azure SQL database is playing up again. This is a regular monthly occurance.
Last month we couldn't connect at all now it is so slow it take minutes to save or retrieve records. Again after a powerapps update!!
Now I'll wait for...give me your Session ID then 5 days of support emails without a resolution for 2 weeks...
Whilst user have to put up with it!
SESSION ID : 1d8270c1-3fb6-4997-8e30-b159be8e00651
Come on Microsoft this is pathetic now!
Solved! Go to Solution.
This is very concerning. I'm currently developing an app with SQL Server using the data gateway. I plan to migrate it to Azure SQL DB. I'm doing it this way since I'm using SQL Profiler to understand PowerApps and to optimize performance. I'm not seeing performance issues using this approach. I've had to clear the browser cache on occasion to get things working properly. What devices are you using to run your app? I use Edge generally and Chrome oocassionally.
You could try testing app by migrating app using an on-premise SQL Server and the data gateway. It works with SQL Server Express (free).
Keep us posted on your progress.
@t19670 Thanks for reporting issue. We identified rootcause and working on resolution. This issue impacted one of Northern Europe data centers due to spike in usage, we will keep you posted once mitigated.
Spoke to soon.... ARRRRGGHHH this is unbelievable!
It seems this morning SQL views are not working correctly with mulitple filters!
This is system wide, please see seesion ID and errors from one of our devices below.
The SQL view isn't working when I have a boolean filter applied if I remove it it works. Although this has been working since March 2018 and now it suddenly breaks!!
PLEASE fix this URGENTLY!
When trying to retrieve a sql view, the error meesage is:
The specified record was not found.
Server response: Invalid Column name 'True'.
Session ID: 8befdc5a-feda-46ea-9a89-d29068c8ad66
Should I start another thread.
I also have an issue with boolean type:
Filter([myTable], column1=false) do not work this morning
I had to change it to Filter([myTable], column1=0). We lost the benefit of delegative query...
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020