Microsoft ends support for original Power BI dataflows
Microsoft has announced the end of life for Power BI's first-generation dataflows, or Gen1. These features will get no new updates and lose support entirely over time. Gen1 relied on basic Pro licenses but could only save prepared data as CSV files. Gen2 dataflows need Fabric F2 capacity or Premium per user, plus an organizational workspace. They connect to advanced storage like Lakehouse or Warehouse and add GitHub tools for deployments and parameters. Migration keeps your existing Power Query M scripts intact. This shift standardizes data preparation around Microsoft Fabric for teams sharing pipelines across reports.
Before, Power BI Pro users could prep data once in Gen1 dataflows and reuse it across reports without extra costs or complex setups. This cut repeated cleaning from messy sources like Excel exports, though limited to CSV and manual refreshes. Now Pro users face a choice: pay for Fabric capacity to use Gen2's better sharing, or embed all Power Query steps directly into each report. Solo analysts gain simplicity with no shared dependencies, but teams lose easy reuse until capacity arrives. The real win is pressure to simplify Power Query chains, fixing those inherited 200-step monsters that take hours to refresh.
Analysis
Forget chasing Gen2 until your company funds Fabric – this news just confirms embedded Power Query in your Desktop reports is the reliable path for fast, independent dashboards. Open your inherited slow report today, replace any Gen1 dataflow with direct Power Query steps, and trim to 20 steps max for refreshes under a minute.
Citation
This executive briefing was curated and analyzed by Collab365. To reference this analysis, please attribute: "This briefing is available on Collab365 Spaces (spaces.collab365.com)".