cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power Apps Staff Mr-Dang-MSFT
Power Apps Staff

Re: SQL problem yet again!!!

@t19670 @Meneghino @AndyGill

Can you confirm that this has been resolved on your end?

Meneghino
Level 10

Re: SQL problem yet again!!!

Thank you @Mr-Dang-MSFT and @katwan, seems that the problem is fixed for the moment.

AndyGill
Level: Powered On

Re: SQL problem yet again!!!

Yep seems okay now. Thank you! 👍
jamess
Level: Powered On

Re: SQL problem yet again!!!

Hi 

 

Can you provide an update on this? It is still an issue. Can the PowerApps team comment on this please?

t19670
Level: Powered On

Re: SQL problem yet again!!!

It’s working but the product team are looking into it. We have been waiting 3 weeks now for an answer on why this keeps happening!

They also got me to run some queries directly on sql server to test the execution times which were almost instant but the sql connector can be upto 30secs to return results.
darwindat
Level: Powered On

Re: SQL problem yet again!!!

Hi all,

 

I got a problem connecting to Azure SQL database. The collections shows all fields when I connect to less SQL tables and the app is not complicated. But when I add more SQL connections and create more screens, the collections doesn't show value in some fields like below picture.

If I connect my app to Excel file (on premise machine), it never happens regardless the complexity of the app. 

My Session ID is: 24eaaa6c-75a7-41f6-8a15-c503108cb7f7. 
 

Thank you very much!

 

Collection from SQL not showing full.png

darwindat
Level: Powered On

Re: SQL problem yet again!!!

Hi everyone,

I would really appreciate your help with my above question. Thanks!

Power Apps Staff Mr-Dang-MSFT
Power Apps Staff

Re: SQL problem yet again!!!

Hi @darwindat,

Can you check if you have the setting for Explicit column selection turned on? It is designed to reduce the columns that you are actually using in the app for better performance. You may have a mismatch of columns in the different places where the table is used with this feature on.

image.png

 

darwindat
Level: Powered On

Re: SQL problem yet again!!!

Thanks @Mr-Dang-MSFT

It was the culprit. It's strange that the columns I am using also disappears while turning on that "Explicit column selection". Anyway, if I turn it off, everything shows again. 

Power Apps Staff LanceDelano
Power Apps Staff

Re: SQL problem yet again!!!

Can you try turning ECS back on and then referencing the columns that don't have data in the app?  You can use a formula or bind it to a UI control like a gallery.  Please let us know if the data shows up. 

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,229)