Dataverse link to Microsoft Fabric

Hi, my friends,

Today I would like to share an exciting feature that I have shared with my colleagues recently.

• Dataverse link to Microsoft Fabric

• Create Virtual Table from Microsoft Fabric

Do you remember the previous data integration patterns for Dataverse? In the past, we relied on exporting data to a DataLake and then utilizing Synapse Link to connect to Azure Synapse via Azure Storage.

And now, Microsoft has introduced a new "Link to Microsoft Fabric" feature, which streamlines this process even further. This feature is similar to the Shortcut functionality when ingesting data into Fabric, offering a more integrated and efficient way to connect Dataverse with Fabric.

Try the feature "Link to Microsoft Fabric"

Go to the Power Apps Maker portal, select the Tables > click the button Analyze > then click the "Link to Microsoft Fabric" button to link Dataverse tables to Fabric.

After signing and passing verifications, you will move to the next step "Chose Workspace" of Microsoft Fabric (Ex: my workspace called "D365 Link"), then click Next and move to the last step "Review & Create".

To complete it, just click the button Create and wait... Then, the new Lakehouse will be created automatically in the MS Fabric workspace.

Within the Fabric workspace, it's possible to access the Lakehouse to engage with data sourced from Dataverse efficiently.

Try to create a Virtual Table from Microsoft Fabric

Now I will share a use case for using Virtual Table which was created from Microsoft Fabric as below.

Ya.. with the Dataflow Gen 2, you can do the ETL data and then store the output to Lakehouse or Warehouse into Microsoft Fabric. For example, as below picture, I used the Dataflow Gen 2 to create an aggregated table "FactExpensebyBuDept" and store this table to Data Warehouse into the Fabric.

After creating the FactExpensebyBuDept table, I will establish a Virtual Table in the Dataverse to retrieve insightful data from Fabric for the D365 App.

Go to the Power App Maker portal, in the solution, click New > Table > Table from external Data. The new dialog will be pop-up and you need to select the connection "Microsoft Fabric"

... then, we just following the step-by-step to create the Virtual Table (as below is these sample steps).

Now.. checking on the Dynamics 365 Application.

This is an exciting feature that allows for the extension of your data and insights within Dynamics 365 and Power Apps in Fabric; brings your data into Fabric and combines, reshapes, and aggregates data with data from Dataverse.

Additional...

I would like to share some info. of this feature that I have explored. Hopefully, it can be helped. 🕰️

1. Benefits

2. Transition diagram

As indicated in the before and after diagrams above, customer retired the Export to Data Lake service (1) as well as staging data stores (2) with Fabric link. For operational insights, (4), they consumed data in OneLake directly in Power BI. Some of the insights require data merge, transformation, and aggregation (3). Instead of using disparate Azure services, they standardized on the same tools built into Fabric.

Yeahhhh... That's my sharing.

Thank you and Hoping well. [NTD]yns.Asia