Migrate From Power BI Desktop to Fabric Dataflows Gen2 in Seconds!

In this video, Austin Libal from Pragmatic Works demonstrates how to seamlessly migrate Power BI Desktop queries into Microsoft Fabric Dataflows Gen2. This process is designed to simplify the transition for users and teams moving toward Microsoft Fabric, an all-in-one analytics platform that supports data engineering, data science, and business intelligence workflows.

What is Microsoft Fabric?

Microsoft Fabric is a comprehensive analytics solution that integrates data ingestion, transformation, and orchestration. It allows users to connect to various data sources, perform transformations, and load data into destinations like Fabric Lakehouses or Warehouses—all within the Power BI service.

Why Migrate to Dataflows Gen2?

Organizations are increasingly adopting Fabric, but many users are hesitant due to perceived complexity. Austin reassures viewers that the migration process is straightforward, especially for those already familiar with Power BI’s Power Query Editor.

Step-by-Step Migration Process

1. Open your Power BI Desktop report and navigate to the Power Query Editor.
2. Identify the queries you want to migrate. These may include multiple applied steps and transformations.
3. Right-click on a query and select Copy.
4. In the Power BI Service, switch to the Data Factory persona and create a new Dataflow Gen2.
5. Paste the copied query directly into the Dataflow Gen2 interface using Ctrl + V.
6. Authenticate your data source when prompted to ensure proper connectivity.
7. Repeat the process for additional queries, or multi-select and copy all queries at once for batch migration.

Benefits of This Approach

• Time-saving: No need to manually recreate transformations.
• Familiar interface: Dataflow Gen2 uses the same Power Query language and UI as Power BI Desktop.
• Scalability: Easily load transformed data into Fabric Lakehouses for broader organizational use.
• Minimal learning curve: Users can leverage existing Power BI skills to work within Fabric.

Final Thoughts

Austin emphasizes that this migration method is ideal for teams looking to modernize their analytics stack without starting from scratch. As long as users can copy and paste and authenticate their data sources, they can quickly transition to Fabric’s powerful dataflows.

For those interested in diving deeper, Pragmatic Works offers additional learning content and a 4-day Fabric Bootcamp to help users go from zero to hero in Microsoft Fabric.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Powert BI and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.