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 / How to connect Dataver...
Power Apps
Answered

How to connect Dataverse Table to Virtual Table to SQL Server Table?

(0) ShareShare
ReportReport
Posted on by 97

Hello,

We initially created a PowerApps application where the source data is being held in the Dataverse as a table. We’ve finalized the application and now we’re needing this data to live on our SQL server. Instead of connecting directly from the Dataverse application to the SQL server, we’ve elected to utilize the Dataverse table due to the formatting and structure of the data. We need the SQL table to mirror what is displayed in the Dataverse table. We’ve gone as far as making a virtual table that mimics the SQL server table but we’re struggling on how to connect the Dataverse table to the Virtual table. Ultimately, we’re wanting the Dataverse table to be mapped to the SQL server table. We’d like to continue to utilize the Dataverse table within our application as the app is completed and we’re just wanting the data stored within our Datawarehouse (SQL Server) and the Dataverse table. Is this possible to do? Any way someone can walk us through how to setup via video conference call. We’ve spent so much time building the application and we feel this is the final step to completing this project. Can someone please help.

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    69,647 Most Valuable Professional on at

    If the changes will always be made in the Dataverse table then the easiest way to do this would be to create a Power Automate flow that runs whenever a row is created or changed in Dataverse. Then have that flow create or change the record in the SQL database.

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 July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 377 Most Valuable Professional

#2
11manish Profile Picture

11manish 165 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 110 Super User 2026 Season 2

Last 30 days Overall leaderboard