Announcements
We have an Azure SQL database that is a clone of our Dataverse database, used for reporting purposes. We were using the MS Data Export Service to do the syncing between the two DBs, and it was working well including keeping the data structures in sync. But now it looks like the Data Export Service tool is being deprecated. I'd like to know if anyone can recommend another tool to use for this purpose. Thanks!
@tschopp
If you want to replicate dataverse data for analytics. I would recommend to use azure synapse analytics for dataverse.
Replicated data can be used for reporting/analytics purpose.
Attached reference link below,
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/azure-synapse-link-synapse
If it answers your question, kindly give kudo and accept it as solution.
Regards,
Prakash
Can Synapse replicate the data into an Azure SQL instance that matches the dataverse datastructure? The article you linked seems to imply it creates a data lake instead.
@umccullough ,
From datalake/synapse use Azure data factory to move data from datalake to Azure SQL database.
As per Microsoft recommended instead of using data export service it is better to use Azure synapse with dataverse.
Recommended link from MS docs
https://docs.microsoft.com/en-us/power-platform/admin/replicate-data-microsoft-azure-sql-database
I'm painfully familiar with what they now recommend - but we have already built a reporting solution around an Azure SQL database that was synchronized with the Data Export Service and it seems they have discontinued that tool.
So per your message, it seems we need to setup synapse + data factory to get the data back into Azure SQL?
@umccullough
yes or else try virtual table provider with dataverse that required custom development using plugin.
Find below reference link, that uses azure sql database and dataverse
https://www.blog.allandecastro.com/custom-virtual-tables-perform-crud-operations-to-another-system/
There are tons of blogs available with sample code, you don't have to develop it from scratch. Just make few amendments w.r.t metadata of your table.
If hope it answers your question, kindly give kudo and accept it as solution.
Unfortunately after trying the Synapse Link and/or Data Factory to export data from Dataverse to Data Lake and/or Azure SQL, we are missing all of the choice field information.
Previously the Data Export Service provided this information in a set of tables called OptionSetMetadata and GlobalOptionSetMetadata, but they are not available in the resulting Data Lake or Azure SQL database after using the newly recommended options.
How do we get these additional details using the newly recommended solution so that we can map the choice integer values to the text labels for reporting purposes?
Unfortunately only tables with change tracking enabled can be exported to data lake. We can't export global option set.
But if any option set present inside an entity that can be exported with table, only integer value gets display.
Do you know what table the option sets and global option sets are stored in the dataverse? perhaps I can export them separately regardless of the change tracking option.
I think we can't export global option set and it's metadata via azure synapse.Hope Microsoft will take care in near future.Regards,Prakash
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 519 Most Valuable Professional
11manish 489
Haque 327
