Azure Synapse Link for Dataverse expands Dynamics 365, Power Platform data analytics options: Build 2021

May 27 2021

Microsoft has updated Azure Synapse Link at Build 2021 with integration to Dataverse. Azure Synapse Link for Dataverse builds on the service formerly known as Export to data lake that had been generally available since October 2019. The renamed and updated service is now in preview.

"With Azure Synapse Link for Dataverse, customers can now automatically ensure that data flowing into their business applications is also flowing into their analytics solution," wrote senior product marketing manager Kaiser Larsen. Larsen explained that Microsoft is focused on making the process easy for owners of Dataverse environments.

As with the existing service, Synapse Link for Dataverse exports initial and incremental data and meta data and can store it either in Azure Synapse Analytics or ADLS Gen2. It works with both standard and custom tables for create, update, and delete transactions.

Microsoft's updates on the offering still contain the typical BI and analytics product marketing language the industry has used for years. It is a "seamless integration" and works in "a few clicks" or even "a single click" to "gain insights". Nevertheless, Microsoft also suggests specific work that can be performed on the incoming data like ad-hoc analysis without provisioning resources, visualization in Azure Synapse, building ETL pipelines using Apache Spark in Azure Synapse for data preparation, data engineering, and machine learning. And Power BI reports can be built against the Azure Synapse Analytics, along with T-SQL capabilities against the data lake. 

Power Apps and Dynamics 365 users can now find a link to Azure Synapse Link in their Power Platform environment. Principal program manager Sabin Nair walks through some of the basics of building the connection, selecting, the tables to export, and building reports against the exported data in Power BI. And the documentation further clarifies prerequisites like proper access to an Azure Data Lake Storage Gen2 account and Synapse workspace.

Microsoft launched Azure Synapse Link for Cosmos DB in 2020.

FREE Membership Required to View Full Content:

Become a MemberLogin
Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also have the option to receive periodic email newsletters with the latest relevant articles and content updates. Learn more about us here
About Jason Gumpert

As the editor of MSDynamicsWorld.com, Jason oversees all editorial content on the site and at our events, as well as providing site management and strategy. He can be reached at jgumpert@msdynamicsworld.com.

Prior to co-founding MSDynamicsWorld.com, Jason was a Principal Software Consultant at Parametric Technology Corporation (PTC), where he implemented solutions, trained customers, managed software development, and spent some time in the pre-sales engineering organization. He has also held consulting positions at CSC Consulting and Monitor Group.

More about Jason Gumpert