Share via

Insights from Microsoft Fabric are available via virtual tables

  • Article
Enabled for Public preview General availability
Users by admins, makers, or analysts Nov 15, 2023 Nov 28, 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 using shortcuts. You can not only join, 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 make.powerapps.com 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 allows you to extend your data and insights in Dynamics 365 and Power Apps in Microsoft Fabric. Bring your own data into Fabric and combine, reshape, and aggregate 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.

Insights aren't complete unless you can drive action and business processes. Bring insights you found in Fabric to build apps, drive business processes with Power Automate without data copy, no-ETL, or non-Microsoft integration tools.

With Dataverse virtual tables sourced with Fabric, your low-code app builders connect to data in OneLake and build apps with Power Apps to drive business actions. Additionally, with Power Pages, low-code makers can build external-facing websites and drive action from OneLake insights with partners, suppliers, and customers.

Additional resources

Link your Dataverse environment to Microsoft Fabric and unlock deep insights (docs)