Build apps with insights in Fabric using virtual tables

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

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

Business value

When you link Microsoft Dataverse to Microsoft Fabric, Dataverse data is available for you to work with Fabric tools. You can combine your data from Dynamics 365 and Dataverse with data in Fabric sourced from your own data warehouses, devices, sensors or linked from other clouds via shortcuts. You can not only join and aggregate, but also apply AI and machine learning to detect patterns and trends. Insights you find aren't useful unless you can drive action with those insights. Now, the insights you find in Fabric, such as KPIs and aggregated data are available back in Power Apps so that makers can build apps and act without having to make copies or use non-Microsoft tools.

Feature details

The Link to Microsoft Fabric feature in Dataverse enables extending your data and insights in Dynamics 365 and Power Apps in Fabric. Bring your own data into Fabric and combine, reshape, and aggregate with data from Dataverse. Use Fabric tools, such as SQL, Spark, and dataflows to work with your data within Fabric. For example:

• Combine financial data from Dynamics 365 with financial data from other systems to derive consolidated insights.
• Merge historical data ingested into OneLake from legacy systems with current business data from Dynamics 365 and Dataverse.
• Combine weblogs and telemetry data from your website with product and order details from Dynamics 365.
• Apply machine learning and detect anomalies and exceptions within your data.

See also

Build apps and automations, drive action with insights from Microsoft Fabric (docs)