Unanswered

Update SQL database with Dataverse Dataset

(0) Share

Report

Posted on by DawsonLaz

We are trying to use power apps to make edits a SQL database, but I can't find a way to sync those changes back to a SQL database. Is there a way to send these changes made to a Dataverse back to the SQL database or can I just use the SQL database directly with a power app.

Thank you all for any help you can give.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

Is this a Canvas or Model Driven App?
Is the data that you want to update ONLY in the SQL or do you need the changes from the App in Dataverse and SQL?

To answer: Yes, you can point your Canvas App directly to SQL, leveraging the SQL Connector / adding SQL Tables directly to your Canvas App (assuming its a Canvas App)

If you need to sync changes from Dataverse to SQL then you have different options.
1. If these are both in the cloud you could use DSF to sync
2. You could use Power Automate to sync the changes.
-Any time a row is updated or created in Dataverse, it could trigger a flow that would write those changes into SQL

3. You could manual export and import into SQL (you can automate this too but it depends on the software or scheduler you use etc.)

There are a bunch of possibilities, but if its minor changes Power Automate is a great option.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
a33ik 3,306 Most Valuable Professional on at

Like (0)

Report
Hello,

There are multiple ways to implement such synchronization:

Power Automate Flow that will handle create/update/delete operations

SSIS that will query the data from Dataverse to SQL - you might use Kingsway Soft adapters

Azure Data Factory

also you can access Dataverse's SQL directly using so-called TDS endpoint - https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query

Was this reply helpful? Yes No
DawsonLaz 4 on at

Like (0)

Report

Hey sorry for the delayed response. But yes, my app is Canvas and I would prefer if the Dataverse and the SQL server were always in sync with each other as I am using this data in a Power BI dashboard and would want the changes that are made to be shown as soon as they are made.

Was this reply helpful? Yes No
a33ik 3,306 Most Valuable Professional on at

Like (0)

Report

If you want PowerBI to use Dataverse as a datasource why not to query the data directly and remove the dependency on the data sync - https://learn.microsoft.com/en-us/power-query/connectors/dataverse

Was this reply helpful? Yes No
DawsonLaz 4 on at

Like (0)

Report

I'm using Analytics services to speed up the processing and to allow it to process more data in power BI.

Was this reply helpful? Yes No