That Blue Cloud

Dataverse to Microsoft Fabric & OneLake Connectivity

The much awaited Synapse Link Dataverse capability for Fabric is here. You can now create a managed Lakehouse within your Fabric tenant with a few clicks, and send your Dataverse data (including Microsoft Dynamics 365) directly into Fabric as delta tables.
Dataverse to Microsoft Fabric & OneLake Connectivity
Dataverse to Microsoft Fabric & OneLake Connectivity

Synapse Link is a great capability, and with the recent news from Microsoft published today, it got even better: Now you can link your Dataverse and Fabric together and query directly from within your Fabric workspace. The best part? It’s completely managed. Apart from a few clicks, you don’t need to do a thing.

Here’s the announcement link:

Microsoft OneLake adds shortcut support to Power Platform and Dynamics 365 | Microsoft Fabric Blog | Microsoft Fabric
Microsoft OneLake is the OneDrive for data providing a single, unified data lake as a service for your entire organization. While OneLake provides a location to store data, shortcuts can virtualize data that you have stored elsewhere into OneLake even if that data resides in another cloud. With shor…

I’ll be keeping this article up-to-date with new capabilities added, or new benefits & drawbacks I encounter.

There's a link at the bottom of this article for a detailed guide from Microsoft.

Setting It Up

For us to establish connection, we need to set it up from both ends. First, we start from the Power BI / Fabric dashboard. Let’s go through the steps:

  1. Go to your Power BI dashboard, click the gear icon on the top right, and choose Manage Connections and Gateways.
  2. Add a new Cloud connection and choose Dataverse as the type.
  3. Get your Dataverse Environment URL from your Power Platform Admin Centre, copy it without any https:// parts into both Connection Name and Environment Domain fields.
  4. Choose OAuth 2 as the authentication method, click Edit Credentials, set it up.
  5. Feel free to choose other boxes, such as Direct Query AAD Support.
  6. Save the form.

Then, you’ll need to go to your Power Apps Admin Centre and create a new connection from there. But keep it in mind, this is very much a preview functionality. It doesn’t even popup in your normal Power Apps admin portal, so you have to use a different link to access:

Power Apps Dashboard & Synapse Link for OneLake
  1. Go to your tables, choose one with data. If you’re using the sample Microsoft Dynamics dataset, choose Contact. It has 13 records in it.
  2. Choose Export > Link to Microsoft Fabric (Preview) button.
  3. It’ll automatically create a Workspace in Fabric, and a Lakehouse in it.
  4. You can go to the Lakehouse right away, but you might encounter Path not found error or the tables might show up under Undefined schema. This is okay, just wait for about 10 minutes for it to properly build the tables.
  5. Then you can go and query the data.
Lakehouse and the Account Table


  • Completely SaaS. You don’t need to do much.
  • In Synapse Link with Data Lake or Synapse Analytics, the files were created as CSV format. But with Fabric the files are created in Delta/Parquet format. So they are automatically recognised by Fabric as tables and works performantly.


  • It’ll only keep the last two years of data in the Lakehouse, based on the record created date. This is to optimise the performance, but keep it in mind.
  • Very, very preview feature. It may change dramatically in the future.

Further Reading

Dataverse direct integration with Microsoft Fabric - Power Apps
Use Azure Synapse Link for Dataverse to export your Microsoft Dataverse data to Azure Synapse Analytics in Delta Lake format to explore your data and accelerate time to insight.
Harun Legoz

Harun Legoz

I’m a cloud solutions architect with a coffee obsession. Have been building apps and data platforms for over 18 years, I also blog on Azure & Microsoft Fabric. Feel free to say hi on Twitter/X!

That Blue Cloud

Design awesome data platforms using Microsoft Fabric

That Blue Cloud

Great! You’ve successfully signed up.

Welcome back! You've successfully signed in.

You've successfully subscribed to That Blue Cloud.

Success! Check your email for magic link to sign-in.

Success! Your billing info has been updated.

Your billing was not updated.