cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
t19670
Advocate II
Advocate II

SQL problem yet again!!!

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! 

 

 

29 REPLIES 29

Yes no longer delegative query if we are using "0" in place of false.

 

Also, from past experience, there will be no answer until the US wakes up.

 

There is no one on here supporting from Microsoft unless it within US waking hours.

 

"[myTable]" is under 500 rows, so it is ok until the issue is fixed

 

Best,

All our businesss critical apps are broken where we have a delegated filter to Azure SQL. 

 

Please fix this ASAP!

OneThing
Continued Contributor
Continued Contributor

As a temporary fix I've added the full table to a collection and then applied filters to this. 

 

This involves a bit of code change thought so not suitable for all.

Ours needs to be filtered into a collection, as the master tables are too big. Not much I can do and we have around 30 PAs...

OilyRag
Frequent Visitor

We have the same issue, can't use the workround without changing all our Apps, so everyone gone home for an early Christmas except me while we find out if there will be a solution - not making me feel very festive ......

Meneghino
Community Champion
Community Champion

Does anyone have any update?  I have raised a ticket with MS but silence...

 

Just copying @Mr-Dang-MSFT on this important issue.

katwan
Microsoft
Microsoft

Hello all,

 

This issue should be mitigated. We fixed some configuration changes in Sql connector. Please try again and let us know if the issue persists.

 

Thanks,

...Katrina

View solution in original post

OilyRag
Frequent Visitor

Checked 2 apps so far and looks to be fixed. 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,225)