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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Deployment Pipeline SQ...
Power Apps
Unanswered

Deployment Pipeline SQL Connection Reference not working properly

(0) ShareShare
ReportReport
Posted on by

Hello everyone,

I developed my Power Pages site in the dev environment, and everything was working correctly. After that, I deployed it to another public-facing environment using the deployment pipeline. Tables and everything else transferred successfully, but despite all reference connections being correctly mapped for the virtual tables, the data does not appear.

Before taking the production environment fully live, I solved this issue by deleting and re-adding the table, but now this is no longer an option. What might I be missing in the deployment process?

I have two virtual tables, each coming from different databases, and I’ve included both the connection references and virtual table data sources in the solution.

What could I be overlooking here?

I have the same question (0)
  • Suggested answer
    SaiRT14 Profile Picture
    1,990 Super User 2025 Season 2 on at
    The issue with virtual table data not appearing after deploying your Power Pages site to a new environment can often be resolved by verifying and addressing these key areas:

    pls try the following:

    Connection References: Ensure all Connection References for the virtual tables are correctly mapped in the target environment after deployment. Test the connections to confirm they are active and have the necessary permissions.

    Virtual Table Data Sources: Verify that the Virtual Table Data Sources are included in the deployment solution. Ensure they are properly configured in the target environment to point to the correct databases.

    Plugin Registration: Virtual tables rely on plugins for data access. Confirm that the required plugins are registered and active in the production environment.

    Dataverse Table Refresh: After deployment, refresh the metadata of the virtual tables to ensure the schema and connections are updated in the new environment. This can often be done by: Revalidating the virtual table configuration in the target environment. Using the "Refresh Tables" option in Dataverse.

     
    Permissions: Confirm that the appropriate permissions and roles are assigned to users in the production environment for accessing the virtual tables.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard