cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
t19670
Level: Powered On

Re: SQL problem yet again!!!

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

 

t19670
Level: Powered On

Re: SQL problem yet again!!!

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.

 

PaulSa
Level: Power Up

Re: SQL problem yet again!!!

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

 

Best,

AndyGill
Level: Powered On

Re: SQL problem yet again!!!

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

 

Please fix this ASAP!

OneThing
Level 8

Re: SQL problem yet again!!!

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.

AndyGill
Level: Powered On

Re: SQL problem yet again!!!

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...

Highlighted
OilyRag
Level: Powered On

Re: SQL problem yet again!!!

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
Level 10

Re: SQL problem yet again!!!

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

 

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

katwan
Level: Powered On

Re: SQL problem yet again!!!

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

OilyRag
Level: Powered On

Re: SQL problem yet again!!!

Checked 2 apps so far and looks to be fixed. 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 31 members 4,229 guests
Please welcome our newest community members: