Upgrading Power BI Dataflows Gen1 is now easier with the Dataflows Upgrade Wizard. Now in preview for eligible workspaces assigned to Fabric capacity, the wizard provides a guided experience to upgrade Power BI Dataflows Gen1 items to Fabric Dataflows Gen2 (CI/CD). The wizard preserves key properties of the existing dataflow and assesses each item before you begin, helping you understand the upgrade scope and expected follow-up actions.
Modernize at your own pace
Power BI Dataflows Gen1 remains supported in a legacy state, while new feature investment focuses on Fabric Dataflows Gen2 (CI/CD), as shared in a previous post about the future of Dataflows. The Upgrade Wizard gives dataflow owners a guided self-service path to start that modernization without rebuilding their Power Query logic.
You don't need to upgrade your full estate at once. Start with a representative set of dataflows, validate the results, and expand at a pace that works for your organization. For detailed migration planning and inventory guidance, review Migrate from Dataflow Gen1 to Dataflow Gen2.
Build on the benefits of Dataflows Gen2
Fabric Dataflows Gen2 (CI/CD) builds on the Power Query authoring experience already used in Power BI Dataflows Gen1, while adding capabilities designed for development, operations, and integration across Fabric.
Dataflows Gen2 supports a broad set of data destinations: Azure SQL Database, Azure Data Explorer (Kusto), Azure Data Lake Storage Gen2, Fabric Lakehouse tables, Fabric Lakehouse files, Fabric Warehouse, Fabric KQL database, Fabric SQL database, SharePoint Files, Snowflake database, and PostgreSQL database. You can begin with the upgraded dataflow and add destinations when you are ready.
As a native Fabric item, Dataflows Gen2 (CI/CD) supports Git integration and Fabric deployment workflows. Teams can bring dataflow definitions into source control, collaborate through established development practices, and move changes across development, test, and production environments. Refresh history and Fabric monitoring experiences provide operational details that help teams review runs and investigate failures.
Capabilities such as Fast Copy, Modern Evaluator, and Partitioned Compute improve performance and scale for different workload patterns. Microsoft's published Dataflow Gen2 cost and performance benchmarks show refresh times improving by 1.6 to 21 times with Dataflows Gen2. Results vary by data, capacity, connector, gateway usage, and query design, so validate your representative workloads.
Dataflows Gen2 (CI/CD) also benefits from tiered Standard Compute pricing, with a lower rate after the first 10 minutes of each mashup-engine query. Separate meters apply to high-scale compute and Fast Copy data movement.
Copilot in Data Factory enhances Dataflow Gen2 authoring with natural language. It can generate transformation steps, create queries, and summarize a query and its applied steps. These capabilities help authors understand and review complex query logic, improving productivity during transformation design.
The bottom line is simple: upgrade now, then modernize when it adds value.
Upgrade one or more dataflows from the same workspace
Ready to begin? Open the menu next to a Power BI Dataflows Gen1 item and select Upgrade to Dataflow Gen2 (Preview). The Dataflows Upgrade Wizard opens with the selected item and lets you add other Dataflows Gen1 items from the same workspace.
Figure: Start the Dataflows Upgrade Wizard from a Dataflows Gen1 item.
The upgraded item preserves its ID, schedule, queries, and connections. Keeping the same item ID helps downstream semantic models and reports continue using the upgraded dataflow without source remapping. The dataflow name also stays the same unless the assessment identifies a required naming change.
After the upgrade is completed, the Fabric Dataflows Gen2 (CI/CD) item replaces the original Power BI Dataflows Gen1 item, and the upgrade can't be reversed. If you need to keep the original Power BI Dataflows Gen1 item, use Save As to create a separate Fabric Dataflows Gen2 (CI/CD) item instead.
Know what needs attention before the upgrade
Before making any changes, the Upgrade Wizard assesses the Power BI Dataflows Gen1 items in your workspace, giving you a clear view of which dataflows are ready and where you may need to act before or after upgrading:
• Ready to migrate: The wizard didn't identify a manual step needed before or after the upgrade. Review the known limitations because the assessment doesn't detect every limitation.
• Needs Attention: You can proceed, but review the reasons and complete the recommended actions.
• Upgrade unavailable: You don't own the dataflow. Ask the owner to upgrade it or use Take over first.
Figure: The assessment shows which dataflows are ready and which need attention.
A Needs Attention status can currently identify incremental refresh, Bring Your Own Lake storage, linked dataflows, possible DirectQuery consumers, or naming changes. Hover over the status to see the reason, then review the Upgrade Wizard documentation for follow-up actions and more information. The scenarios represented by each assessment status may expand as we further enhance the assessment capabilities.
After the upgrade
Once the wizard finishes, complete these follow-up steps to validate your upgraded dataflows and reconnect any dependencies.
• Refresh each upgraded dataflow to load its data.
• Open and save each downstream dataflow to rebind it.
• Complete any remaining recommended Needs Attention actions.
• Update consumers (for example, semantic models or linked dataflows) using the legacy Power BI Dataflows connector to the modern Power Platform Dataflows connector. The assessment doesn't detect legacy connector use.
Learn more
Ready to explore the Upgrade Wizard? Review the prerequisites, assessment guidance, and complete workflow in Upgrade Dataflow Gen1 to Dataflow Gen2 (CI/CD) using the Upgrade Wizard. We look forward to hearing about your experience during preview.
Microsoft Employee
