Microsoft Fabric Updates Blog

Analyze Dataverse tables from Microsoft Fabric

We are excited to announce we’ve made it easier than ever for Dynamics 365 and Power Apps customers to extend their insights into Fabric. In November 2023 we announced the ability to Link to Fabric from the Power Platform Maker Portal. This allows makers to easily analyze their data in Fabric through a single action in the maker portal.

Now, we’ve extended this capability from the Fabric side. When creating a shortcut within Fabric, you will now see an option for Dataverse. When you choose this shortcut type and specify your Dataverse environment details, you can quickly see and work with the tables from that environment.

Shortcuts in Microsoft OneLake allow authorized users to connect directly to their existing data.  You no longer need to copy data from a source system to an analytical engine.  Instead, you simply create a shortcut and immediately start analyzing your data in Fabric.

From Fabric, you can also connect to multiple Dataverse environments. This unlocks some historically challenging analytical scenarios. Customers implement separate Dataverse instances for logical businesses reasons such as for separate application customizations, contact databases, product lines, or departments. While that makes things easier for the business application end users it can make it challenging for executives who need to see data across the whole business. With this new feature, OneLake can virtualize data across Dataverse environments to provide a comprehensive view of data for analytics and reporting.

In addition to being able to access core Dataverse entities through shortcuts, you can also access ready-made insights and rich datasets in Dynamics 365 apps. Why build datasets from the ground-up when you can use and extend simplified data models built into apps like Dynamics 365 Customer Insights – Journeys?  Starting in March, D365 Customer Insights – Journeys data will be available through Dataverse shortcuts in Fabric. This allows you to gain a complete understanding of your campaigns, lead management, market performance, customer engagement, and ultimately enabling you to identify new opportunities.

Let’s take a look at how to use Dataverse shortcuts in Fabric.

Prerequisites:

  • A Power Bi premium license or Fabric Capacity
  • If you don’t have Power BI premium license or Fabric capacity, you can sign up for a Free Fabric trial capacity. More information: Fabric (preview) trial
  • System administrator privileges for your Dataverse environment.
  • Enable Link to Fabric from the Dataverse environment.

Create a Dataverse shortcut in Fabric:

  • Start by opening Fabric fabric.microsoft.com
  • Create or open a Workspace.
  • Create or open a Lakehouse.
  • From the Lakehouse choose “Get data” and select “New shortcut”A screenshot of a computer

Description automatically generated
  • Select Dataverse from the shortcut source types.

A screenshot of a computer

Description automatically generated

  • Supply your Dataverse environment URL (Example: orgname.crm.dynamic.com) and the credentials that you want to access the environment with. Note, Dataverse shortcuts utilize a delegated authorization model. All data access through the shortcut will utilize this credential.  This credential must have the System Administration permission in the Dataverse environment.  As you are a system administrator to the Dataverse environment, you will see all the data from your environment. You should secure access to this workspace before sharing this data with your users.
  • Choose the table(s) that you want to create a shortcut to. Each table will be its own shortcut in the Lakehouse. If you’re not seeing all your tables, you may need to configure your Dataverse environment. From the Power Platform Makers portal, use “Link to Microsoft Fabric” to update the available tables.

A screenshot of a computer

Description automatically generated

A screenshot of a computer

Description automatically generated

  • With your tables now available in your Lakehouse you can now start analyzing your data with Fabric. Use Dataverse shortcuts with Spark Notebooks, the SQL endpoint and Power BI reports.

From your Lakehouse you can open the SQL endpoint and start writing queries against your data.
A screenshot of a computer

Description automatically generated

A screenshot of a computer

Description automatically generated

Choose the Data tab and select New report. Use Power BI to create a new report from your data or have CoPilot help you get started.

A screenshot of a computer

Description automatically generated

We are thrilled to release this new Dataverse shortcut to empower businesses around the world to achieve more with Fabric and Microsoft Business Applications.

Join us at the Microsoft Fabric Community Conference on March 25th and see this integration live at the workshop: Unleash Dynamics 365 Value with Microsoft Fabric – Microsoft Fabric Community Conference (fabricconf.com)

Related blog posts

Analyze Dataverse tables from Microsoft Fabric

October 4, 2024 by Jason Himmelstein

We had an incredible time in our host city of Stockholm for FabCon Europe! 3,300 attendees joined us from our international community, and it was wonderful to meet so many of you in person. Throughout the week of FabCon Europe, our teams published a wealth of valuable content, and we want to ensure you have … Continue reading “Fabric Community Conference Europe Recap”

September 30, 2024 by Matt Basile

You can now delegate access to OneLake using short-lived OneLake shared access signatures (SAS). OneLake SAS make it easy to provide limited access to applications which may not support Microsoft Entra, as well as support applications serving as proxy layers between users and their data in OneLake. OneLake SAS follow security best practices for delegated … Continue reading “OneLake shared access signatures (SAS) now available in public preview”