Showing results for 
Search instead for 
Did you mean: 
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?

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 ?




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


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

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


Join PowerApps User Group!!

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

Top Kudoed Authors
Users Online
Currently online: 315 members 2,991 guests
Please welcome our newest community members: