web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / SQL Connector Refresh Lag
Power Apps
Unanswered

SQL Connector Refresh Lag

(0) ShareShare
ReportReport
Posted on by 111

Hello,

 

I've noticed that when I create a new table in my SQL database, it's not instantly available in the app like it is when I use PowerBI. I'm just wondering if someone can help me understand the reason behind this lag so I can see if I can either time it or figure out a workaround to make it a little quicker. It's an On-Premise through a gateway but PowerBI is going through the same setup as well.

 

Anyone else experiencing this?

Categories:
I have the same question (0)
  • v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @DTreg1 ,

     

    I haven't met such issue and not sure what happened, but I would recommend you to Restart the On-premises data gateways service, that should make the new table show up in PoweApps.

    Hope this helps.

    Sik

  • DTreg85 Profile Picture
    111 on at

    Hello @v-siky-msft 

     

    Without doing anything, it shows up after some time. I don't see the restart as being the issue as I'm using the exact same gateway for PowerBI. When I add a column to a table in SQL, it instantly shows up in PowerBI when I go to that table, but not in PowerApps, I have to let it sit and check back about a half hour later, causing me to lose momentum. If it was a restart issue, I would expect to see this same lag to be in both PowerBI and PowerApps. This would also not be a viable solution to restart the gateway every time I add a column to a table.

     

    I appreciate the suggestion though, thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 325 Most Valuable Professional

#2
11manish Profile Picture

11manish 165

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 88 Super User 2026 Season 1

Last 30 days Overall leaderboard