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 / Deployment Pipeline SQ...
Power Apps
Suggested Answer

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 1 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 273

#3
Kalathiya Profile Picture

Kalathiya 232 Super User 2026 Season 1

Last 30 days Overall leaderboard