Microsoft Fabric Updates Blog

Microsoft OneLake adds shortcut support to Power Platform and Dynamics 365

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 shortcuts, data will appear in OneLake as if it were physically there without any data movement or duplication.

We are excited to announce you can now create shortcuts directly to your Dynamics 365 and Power Platform data in Dataverse and analyze it with Microsoft Fabric alongside the rest of your OneLake data. There is no need to export data, build ETL pipelines or use third-party integration tools. Simply click Link to Microsoft Fabric and you can start working with your data immediately.

Link to Microsoft Fabric

To get started, open the Power Apps maker portal at https://make.preview.powerapps.com where you see all your Dataverse tables. Right-click on a table and select Link to Microsoft Fabric.

A Fabric lakehouse is created for you with a OneLake shortcut. The shortcut makes your table data appear as though it has been copied into the lakehouse; however, it is a reference to the Dataverse location where the entity is stored. Each time you select a new table and click Link to Microsoft Fabric, a new shortcut is created in the lakehouse.

A screenshot of a computer

Description automatically generated

The table data in the Dataverse is now formatted using the Delta\Parquet standard. All workloads within Fabric natively support this format. You can analyze your data with Spark, SQL, and Power BI reports without any data transformation.

A screenshot of a computer

Description automatically generated

Synapse Link

If you are already using Synapse Link for Dataverse, your transition to Fabric just got easier. Open the Power Apps maker portal and choose Synapse Link. Right-click on your link profile and select Link to Microsoft Fabric. A new lakehouse is created for your link profile and a new shortcut is created for every table in that link profile. The shortcut points to the ADLS storage account configured for the synapse link rather than the Dataverse location. You can immediately start using Fabric without interrupting any of your existing processes for extracting and analyzing data.

A screenshot of a computer

Description automatically generated

For a detailed guide on setting up Dataverse integration with Fabric see the document here.

Watch the video below to see it in action.

Zugehörige Blogbeiträge

Microsoft OneLake adds shortcut support to Power Platform and Dynamics 365

Oktober 7, 2024 von Alex Lin

Introducing Managed VNet Support for Fabric Eventstream! By creating a Fabric’s Managed Private Endpoint, you can now securely connect Eventstream to your Azure services, such as Azure Event Hubs or IoT Hub, within a private network or behind a firewall. This integration ensures your data is securely transmitted over a private network, enabling you to … Continue reading “Secure Data Streaming with Managed Private Endpoints in Eventstream (Preview)”

Oktober 4, 2024 von 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”