At Microsoft Build 2026, we're focused on what every developer and data team already knows: the most ambitious AI applications are only as good as the data behind them. Fabric Data Factory is the integration foundation of Microsoft Fabric—built to help builders move data with confidence, ground their AI on trusted sources, and ship intelligent experiences faster.
Native to Fabric and powered by OneLake, Fabric Data Factory unites proven Azure Data Factory capabilities, modern low-code experiences, and deep AI integration in a single, SaaS-first platform. The result isn't just easier for data integration—it's a developer-ready foundation for the next generation of AI apps, agents, and analytics.
This year at Build, Fabric Data Factory gets more resilient for mission-critical workloads and more productive for every skill level—from citizen developers to pro-code data engineers. From deeper diagnostics and private-network mirroring to the next wave of dbt, to AI-assisted Airflow authoring and a smoother path from Azure Data Factory to Fabric, the announcements that follow reflect the pace of innovation customers can build on.
Figure: Fabric Data Factory Capabilities.
Mission critical data integration
Every AI application, analytics workload, and downstream insight inherits the trust posture of the data behind it. Fabric Data Factory delivers enterprise-grade security, governance, and operational visibility—so teams can move fast on integration without trading away the controls.
At Build, we’re putting deeper operational visibility into the hands of administrators with a new capability.
Preview
- Enhanced Dataflow Gen2 diagnostics with OPDG logs — richer, end-to-end logs for Dataflow Gen2 runs that traverse the on-premises data gateway, so teams can pinpoint failures faster and keep mission-critical refreshes on schedule.
Generally Available
- Secure ingestion into Fabric Data Warehouse with Copy job and Copy activity — Copy job and Copy activity now support workspace staging in the most locked-down network topologies our enterprise customers run:
- Fabric Data Warehouse is fronted by a workspace private link.
- Workspaces with outbound access protection enabled, routed through a VNet data gateway or on-premises data gateway (OPDG).
Combined with the security, governance, and private-network capabilities already in Fabric Data Factory, this makes Fabric Data Factory a platform you can trust for regulated industries and enterprise-scale operations—where reliability is non-negotiable.
Unified and governed data estate
The fastest path to AI-ready data is one that doesn't require copying it multiple times to get there. Fabric Data Factory empowers customer to unify their data estate with OneLake, and getting from raw data to AI-ready data that every Fabric workload can build on. At Build, we’re extending mirroring with secure, private connectivity that customers have asked for.
Preview
- Mirroring with Workspace Private Link for Azure SQL DB, SQL Server (2016–2022), SAP Datasphere, and SharePoint List—bring four of the most-requested enterprise sources into OneLake over private, governed networks.
- Open mirroring integration with Stelo—stream change data in real time into Fabric without pipeline rebuilds, enabling low-impact, near real-time data replication from various enterprise data sources.
High-performance and cost-effective transformation
Transformation is where raw data becomes something teams—and models—can use. Fabric Data Factory combines Dataflow Gen2's self-service authoring, with dbt's code-first SQL workflows, so analysts and engineers can work with the best tools for high-performance data transformation.
Generally Available
- Dataflow – Execute Query API (Streaming API) — programmatic, low-latency execution of Power Query queries against live data sources.
Preview
- Mapping Data Flows (MDF) Transform — Coming the week of June 8, Azure Data Factory’s Mapping Data Flow transformations are now available within Dataflow Gen2, giving customers low-code Spark-scale data engineering inside the modern Fabric authoring experience.
- Performance enhancement: Warehouse → Lakehouse — Optimized data movement from Warehouse (DFG2 Staging Compute) to Lakehouse (Data Destination) for the most common modern lakehouse pattern.
- My Queries — Streamline reuse and productivity by enabling users to manage frequently used queries in one place, reducing duplication and accelerating data preparation workflows.
- Modern Get Data in Power BI Desktop — Modern Get Data in Power BI Desktop brings a modernized Power Query experience that makes it faster and easier for customers to find and connect to the data they need—using the OneLake Catalog for Fabric data discovery and a streamlined connector experience across the 170+ Power Query connectors. It simplifies everyday tasks like authentication and setup, reducing friction so users can spend more time analyzing data and less time configuring it.
Since introducing dbt jobs in Fabric Data Factory, we’ve been learning how teams use dbt to power SQL-based transformations in Microsoft Fabric—and what matters most as they scale. The next wave of dbt job enhancements is here.
dbt job Preview
- dbt job pipeline activity and UX improvements — Orchestrate dbt directly from Fabric pipelines, with a more polished authoring experience.
- dbt job API — Programmatic control of dbt jobs for CI/CD and DevOps workflows.
- dbt job export project — Round-trip your dbt project between Fabric and the tools you already use.
Learn more about dbt jobs to start modeling data with dbt.
Enterprise grade orchestration: Low code and pro code
Modern data work spans drag-and-drop pipelines, code-first DAGs, and—increasingly—AI-assisted authoring, often inside the same team. Fabric Data Factory unites pipelines, Apache Airflow, and Copilot-style assistance under one orchestration roof, so teams don't have to splinter their workflow across disconnected tools.
Generally Available
- Refresh SQL analytics endpoint pipeline activity — A first-class step for keeping the SQL analytics endpoint in sync as part of pipeline runs.
Preview
- Approval Activity for business workflows — Weave human approvals into pipelines for governance-driven scenarios.
- Materialized Lakeview Refresh activity — Keep your materialized lakeview fresh as part of pipeline runs.
- Pipeline Conditional Retries — Retry the right activities under the right conditions, not blindly.
- Updated pipeline canvas for large pipelines — A smoother authoring experience for sprawling, real-world graphs.
- Connection and Item reference support for Pipelines — Cleaner, more portable references that simplify dev-to-prod promotion.
- Airflow Workspace Identity and Variable library — Identity-bound Airflow with shared variables across DAGs.
- Airflow Copilot — Natural language assistance for authoring and debugging Airflow DAGs.
Read the Data Factory Orchestration Documentation to learn more about these new enhancements.
Multi-cloud data distribution: At scale, across all clouds
Real enterprise data lives everywhere—across clouds, on-premises systems, and business-critical platforms like SAP. Fabric Data Factory's Copy job keeps extending its reach: more sources, smarter incremental and CDC patterns, and native SAP extraction that brings core business data into Fabric without custom plumbing.
Generally Available
- Copy job CDC for Azure SQL DB, Azure SQL MI, and SQL Server — Production-ready change data capture across the SQL family.
- Switch full / incremental copy post-creation in Copy job — Change strategy without rebuilding the job.
- Edit Copy job via JSON payloads — Pro-code edits for teams that prefer source-controlled definitions.
- Activator support for triggering Copy job — Event-driven movement integrated with the Fabric Activator surface.
- Truncate Destination before Full Copy in Copy job — Eliminate duplicate rows by clearing the destination ahead of a full reload.
- Copy job now supports more destinations — GBQ, MySQL and PostgreSQL as destinations to empower multi-cloud data movement.
Preview
- Extended SCD Type 2 support in Copy job to Fabric Warehouse — Standardize slowly changing dimension patterns natively against Fabric Warehouse and Synapse SQL pool.
- Auto-partitioning in Copy job for Oracle, SAP HANA, and Lakehouse — Better parallelism without hand-tuning.
- Copy job for SAP with ABAP add-on — Native, high-throughput extraction from SAP via ABAP-aware Copy job.
Agentic data integration
Fabric Data Factory is now agent-ready: AI agents and Copilot-style assistants can author, operate, and diagnose every Data Factory item through a single, evaluated skill set.
Preview:
- Data Factory Skills — Authoring, consumption, and diagnostics skills for Pipelines, Copy job, and Connections & Gateways, joining the existing Dataflow Gen2 skills to give AI agents full coverage across every Data Factory item type.
- Airflow support for Data Factory MCP — Extends agent-driven authoring and diagnostics to code-first Airflow DAGs, unifying AI authoring across low-code and pro-code orchestration.
Seamless upgrade to Fabric Data Factory
Fabric Data Factory is where Microsoft's data integration story is heading—and we’ll partner with you on the journey from Azure Data Factory to Fabric Data Factory to make sure you are empowered with a seamless upgrade experience. We are excited about the following additions to Fabric Data Factory that will enable you to leverage some of your favorite ADF features (e.g. Mapping Data Flows) in Fabric Data Factory.
Preview:
- Mapping Data Flow (MDF) support with the migration tool — Coming the week of June 8, bring your existing MDF assets to Fabric Data Factory with a guided experience.
- Open the migration tool from the Fabric migrate pane — A single, in-context entry point for the migration journey.
With feature-rich parity, modern capabilities, and seamless migration experience, Fabric Data Factory is ready for customers to confidently adopt as their next-generation data integration platform.
A stronger foundation for what’s next
Fabric Data Factory isn't just a set of features, it's an end-to-end data integration platform built for how modern teams work: across clouds, across skill levels, and increasingly, alongside AI. The innovations landing at Build make that foundation more resilient, more unified, and more productive—so the analytics, applications, and agents your teams build on top of it can move at the pace of the business.
We're excited to put these capabilities in your hands at Microsoft Build 2026. Now it's your turn—we can't wait to see what you build.
Learn more:
- Learn more about Data Factory in Microsoft Fabric
- Get Started with Microsoft Fabric
- What’s new and planned for Data Factory in Microsoft Fabric
- Read other in-depth, technical blogs on the Microsoft Fabric Updates Blog