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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Update Existing Virtua...
Power Apps - Microsoft Dataverse
Unanswered

Update Existing Virtual Table Datasource with New connection.

(1) ShareShare
ReportReport
Posted on by NA-26080819-0 2
Hi Team,
 

Context:
In my solution, I have several virtual tables created using the Virtual Data Connector Provider. The original connection reference for the provider was created by a user account that is now disabled.

To resolve this, we updated the connection reference with a new, active connection. However, the existing virtual tables are still not retrieving data from SQL, even though the new connection appears to be valid.

 

What We've Tried:

  • Verified that the new connection is active and has appropriate permissions.
  • Confirmed that the connection reference was successfully updated in the environment.
  • Checked the virtual table metadata (External Name, External Collection Name) — no changes were made.
  • Attempted to refresh the metadata and re-publish the solution.
 

Question:

How can we update the existing virtual tables to use the new connection reference so that data starts flowing again from SQL?
Is there a supported way to rebind the virtual tables to the updated connection, or do we need to recreate them entirely?

Any guidance or best practices would be greatly appreciated.

 
 
Categories:
Entities
Tables
Microsoft Dataverse
I have the same question (0)
  • Pstork1 Profile Picture
    Pstork1 67,902 Most Valuable Professional on at
    Update Existing Virtual Table Datasource with New connection.
    How long did you wait after adding the new connection to the connection reference?  In my experience connections are cached and it takes several hours, usually overnight, before the new connection is used.  Also after updating the connection reference did you publish all changes before re-importing the solution?

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     

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

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 973 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 366 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 343

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans