View Dataverse data in Microsoft Fabric

Important

This content is archived and is not being updated. For the latest documentation, go to Microsoft Dataverse documentation. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for Public preview General availability
Users by admins, makers, or analysts Sep 8, 2023 Nov 25, 2023

Business value

Microsoft Dataverse direct integration with Microsoft Fabric enables organizations to extend their Dynamics 365 enterprise applications and business processes into Fabric. The View in Microsoft Fabric feature built into Power Apps makes all your Dynamics 365 and other data from Power Apps available for analysis in Fabric.

  • No need to export data, build ETL pipelines, or use third-party integration tools.
  • Link data from Dataverse directly into Fabric, no need to bring your own storage.
  • Link existing Azure Synapse Link for Dataverse links to Fabric.

Feature details

With deep links in Power Apps (make.powerapps.com) and Dynamics 365 apps, makers can jump to action and work with Fabric directly. The system links your data securely with Fabric workloads such as Lakehouse and Data warehouse.

As data gets updated, changes are reflected in Fabric automatically. Dataverse also generates an enterprise-ready lakehouse and SQL endpoint for your Dynamics 365 data. This makes it easier for data engineers and database admins to combine data from multiple sources and build custom analytics with Spark, Python, or SQL.

Microsoft OneLake, built into Fabric, helps to eliminate data silos. Combine data from your applications and devices—web sites, mobile apps, sensors, and signals from your warehouse and factories—with data from your business processes in Dynamics 365—sales, cases, inventory, and orders—to predict potential delays or shortages that affect keeping your promises to customers.

Makers can build low-code apps and automations to orchestrate business processes and react to insights found in Fabric. Add those insights back to Dataverse as virtual tables connected to Fabric OneLake. Makers can turn them into low-code apps with Power Apps, Power Pages, or Power Automate using the design tools already available. Using connectors to over 1,000 apps, makers can create business processes that span Dynamics 365 as well as many other enterprise applications.

See also

View Dataverse data in Microsoft Fabric (docs)