Unanswered

Update Existing Virtual Table Datasource with New connection.

(1) Share

Report

Posted on by NA-26080819-0

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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Kimia_S-06112345-0 16 on at

Like (0)

Report

Update Existing Virtual Table Datasource with New connection.

Hi @NA-26080819-0,

You should try to

1- Create virtual tables again.

2- Choose the new connection and ensure to check the environment variable for ALM purpose.

3- The metadata you set before will pop-up

4- Finish the process

5- From Advanced -> Publish table

Your virtual table will be updated and connected via the new connection.

Was this reply helpful? Yes No