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


Power Apps Community User Group Member Badge

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


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


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (6,028)