# 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***](https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts) 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"

{% hint style="success" %}
For the prerequisites of enabling this feature, you can find detailed information [here](https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-view-in-fabric#prerequisites).
{% endhint %}

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.

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2Fag1UZLzsn8DZwJSYUcbG%2FCleanShot%202024-09-02%20at%2022.25.18%402x.png?alt=media&#x26;token=7f5b942e-cd7f-4ce7-9c1b-17743d140bec" alt=""><figcaption><p>Using the Link to MS Fabric feature</p></figcaption></figure>

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".**

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2FBfsjSdgHWGd8kXaLYwEa%2FCleanShot%202024-09-02%20at%2022.27.37%402x.png?alt=media&#x26;token=1eee9869-c3c6-4865-8067-7f06ea623047" alt=""><figcaption><p>Configurations to link Dataverse to MS Fabric</p></figcaption></figure>

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

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2FPPp2RNO76ZFRu37PTVf9%2FCleanShot%202024-09-02%20at%2022.37.03%402x.png?alt=media&#x26;token=330df3d9-42d3-4de0-ab20-9b402dca3868" alt=""><figcaption><p>The new Lakehouse in the MS Fabric</p></figcaption></figure>

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**&#x20;

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

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2FnmPF88zuI63xmwZY67ZL%2FCleanShot%202024-09-03%20at%2008.54.54%402x.png?alt=media&#x26;token=ea974dc5-43bf-4f03-a002-2063780f1e17" alt=""><figcaption><p>Use Case &#x26; Simple steps</p></figcaption></figure>

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.

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2FZsHdP9MpIBQD7Hw0Flq4%2FCleanShot%202024-09-03%20at%2009.02.37%402x.png?alt=media&#x26;token=9c64a859-70e0-4ce3-886a-23d60e1beaf4" alt=""><figcaption><p>Dataflow Gen 2: Transform - Aggregation - Store the Output</p></figcaption></figure>

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"**

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2FcTudDO0zYp0RvYpCS61R%2FCleanShot%202024-09-03%20at%2009.30.49%402x.png?alt=media&#x26;token=ef1767b8-70e4-4972-8975-a3011c5c3c1d" alt=""><figcaption><p>Create Virtual table</p></figcaption></figure>

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

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2FpOWUl9XmarSd8MOD6p2k%2FCleanShot%202024-09-03%20at%2009.35.33%402x.png?alt=media&#x26;token=6d22fc24-99c9-432d-acfe-03063dfa030d" alt=""><figcaption><p>Completion: Virtual table "FactExpensebyBuDept"</p></figcaption></figure>

Now\.. checking on the Dynamics 365 Application.

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2FvSjUw28v9VHsousftif0%2FCleanShot%202024-09-03%20at%2009.38.04%402x.png?alt=media&#x26;token=1afc32b7-63b0-42a1-89bc-820a73b9a110" alt=""><figcaption><p>Add the Virtual table into Dynamics 365 Application.</p></figcaption></figure>

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.&#x20;

***

## Additional...

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

### 1. Benefits

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2FNpZBcVPdjbE8SuBMzwom%2FCleanShot%202024-09-02%20at%2022.17.54%402x.png?alt=media&#x26;token=2f50e48e-8489-4e38-b344-18ef5b7bd88b" alt=""><figcaption><p>Benefit of Link to Fabric feature</p></figcaption></figure>

### 2. Transition diagram

<figure><img src="https://4233060750-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjhtQupP7ACZVtv3cCNCr%2Fuploads%2FBI3xH3BuErPNhWPtfOQS%2FCleanShot%202024-09-03%20at%2009.23.15%402x.png?alt=media&#x26;token=5779fe07-7983-4c29-8c0d-e6864c171557" alt=""><figcaption><p>Transition diagram</p></figcaption></figure>

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.

{% hint style="info" %}
For more details and another cases, please find the link: [Transition from legacy data integration services to Fabric link and Azure Synapse Link for Dataverse - Power Apps | Microsoft Learn](https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-transition-from-fno)
{% endhint %}

Yeahhhh... That's my sharing.&#x20;

Thank you and Hoping well.\
\&#xNAN;**\[NTD]yns.Asia**