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

Data Tables Not Loading SQL Data When App is Published

Hi, I'm really stuck on this issue.

 

I have both views and tables that are simply not loading contents when I publish my PowerApp.

 

While editing the app and testing, the data loads perfectly fine for each screen. After publishing, the data does not appear and even after waiting some time it does not load. My app has 11 different SQL connections to different tables and views (same db) and 2 of them work when publishing, ironically they were the first 2 I set-up. Is something being delegated here automatically without me realizing it?

 

Should I be using Collections in some way here?

 

I'd really prefer to be able to send the data to the client and have it rest in an offline mode until the user were to click a "Refresh" button or something. I'd settle for a way for data to only pull when OnVisible too. I would just compare performance.

 

Does anyone have a reccommendation?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Data Tables Not Loading SQL Data When App is Published

Have you tried with another control, for example, a gallery?

Besides, would you please share more details about how many Database resources has been added, and the corresponding type like whether gateway is used, authentication method ?

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
jared_simmons
Level: Powered On

Re: Data Tables Not Loading SQL Data When App is Published

All connections are using the same Basic Auth on an Azure SQL db, no gateways.

 

I didn't try a different control because I didn't want to upsurp my settings and properties I already had named with the data tables.

 

The two connections that are working are using the Gallery control while all others were tables.

 

My org is on Version 3.18081.22, is this the latest?

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 318 members 5,836 guests
Please welcome our newest community members: