Dataflows - Dynamic Schema Support for Fabric Data Warehouse Destination

Data Factory · Public preview · Shipped

Data Factory Public preview Shipped
Last Modified: October 07, 2026 Release Date: Q3 2026

Description

Dataflows Gen2 will expand support for Dynamic Schema mode when writing to Fabric Data Warehouse destinations, making it easier to handle evolving data without manual rework.With Dynamic Schema, Dataflow Gen2 can automatically adapt to changes in your query schema--such as added or modified columns--when publishing data to a warehouse. This removes the need to pre-define and rigidly maintain table schemas as your data evolves.Why this matters:* Faster iteration: Update transformations without blocking on schema alignment.* Schema-flexible pipelines: Land evolving datasets into a warehouse with less friction.* Simpler migrations: Common Gen1 and self-service scenarios that rely on schema evolution become easier to move to Gen2.This capability is especially valuable for transformation-heavy pipelines and self-service data preparation, where schemas naturally change over time, and aligns Dataflow Gen2 more closely with the flexible, modern data engineering patterns supported across Microsoft Fabric.

📰 Related Blog Article

New Dataflow Gen2 data destinations and experience improvements
🔗 community.fabric.microsoft.com

Change History

  1. 2026-10-07
    Release Status Planned -> Shipped
  2. 2026-06-16
    Restored to Roadmap
  3. 2026-06-16
    Removed from Roadmap
  4. 2026-06-02
    Roadmap Item Added
← Back to Roadmap 👁️ Watch this Feature View API JSON Workload: Data Factory