cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
better
Advocate I
Advocate I

Azure SQL new tables, columns and view updates taking ages to show up in Power Apps

Has anyone else noticed it can take up to 30 mintues before Azure SQL changes show in Power Apps Canvas? this never used to happen.

 

Here is what Microsoft had to say

"Greeting for the day. Hope you are doing well!

If you create and field in view/table then to get updated field quickly in PowerApps, you need to create data source again.
By default, PowerApps will take some time to reflect field which has been created in Azure SQL.

Appreciate for your valuable time and I look forward to assisting you! "

 

Most times when i update SQL it takes quite a while to show in Power Apps Canvas.  It doesnt matter how many times i hit Refresh data. i can delete the table/view and re add it, no change. the only thing that works is adding a new connector to Azure SQL.  what a mess!

 

Development is taking quite a while now...

1 REPLY 1
PaulD1
Super User
Super User

I'm not currently doing any development against SQL (thanks to the licensing changes) but I recall this came up about a year ago as well (changes to SQL table/view structures taking a long time to be reflected in PowerApps).

I don't recall ever seeing a specific reason or resolution - it just got really slow for a week or two and then went back to normal.

May be worth raising a ticket with MS? Try to determine what is the 'expected time range' to see the changes and then raise a ticket again any time you see it go beyond that range. Agree that having to wait half an hour to see your SQL changes in a 'rapid development tool' is not really on...

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (38,421)