Skip to main content
Data Platform

Azure Data Factory vs Fabric Data Factory: Migration, Triggers, Linked Services and Runtime Costs

Fabric Data Factory looks like Azure Data Factory with a new coat of paint, so teams assume a migration is a lift-and-shift and schedule a weekend for it. Then they discover the trigger model is different, linked services became connections, the integration runtime concept changed, and the cost moved from a per-activity bill to capacity consumption. It is a migration, not a rename, and the parts that differ are exactly the parts that run your production loads at 3am.

Amit Kumar Singh - Technology Consulting Partner at MyData Insights

Technology Consulting Partner · MyData Insights

14+ years in industrial data · Former Accenture & EY · India, GCC, SEA

26 October 2026 · 10 min read

The bottom line

Fabric Data Factory shares ADF's pipeline heritage but differs in the places that matter for a migration. Triggers: ADF's schedule, tumbling-window and event triggers map onto Fabric's scheduling and the event-driven Data Activator, but not one-for-one, so trigger logic is re-created, not copied. Linked services become connections managed at the tenant/workspace level, with on-premises access through the on-premises data gateway rather than a self-hosted integration runtime. Dataflows Gen2 replace mapping/wrangling data flows with a different authoring surface. And the cost model changes fundamentally — from ADF's per-activity-run and IR-hours billing to Fabric capacity (CU) consumption, which can be cheaper or dearer depending on workload shape. Where it breaks: there is no true one-click migration, heavy custom ADF patterns need rebuilding, and capacity contention is a new failure mode.

It shares DNA with ADF — and that is the trap

Fabric Data Factory is built on the same pipeline engine as Azure Data Factory, so the authoring experience is familiar and much of the activity library looks identical. That familiarity is useful and also the source of the trap: teams assume parity and plan a mechanical migration, then hit the areas where Fabric deliberately does things differently because it lives inside a unified SaaS platform rather than as a standalone Azure service.

The differences cluster in four places — triggers, connections and gateways, data flows, and the cost model — and each one touches production operation. A migration that respects those differences is straightforward; one that assumes a rename discovers them during the first failed overnight load. Plan it as a migration with a parallel-run period, not a cutover.

Triggers and scheduling are not one-for-one

ADF has three trigger types — schedule, tumbling window, and storage/event — and production pipelines often lean on their specific behaviours, particularly tumbling window's dependency and backfill semantics. Fabric handles scheduling natively on pipelines and brings event-driven execution through Data Activator (Reflex) and event streams, but the mapping is not literal: tumbling-window dependencies and backfill in particular need re-expressing rather than copying, and event triggers are wired through Fabric's eventing rather than an ADF event trigger.

The practical implication is that trigger logic is re-created and re-tested, not exported. For most schedule-based pipelines this is quick; for pipelines that depend on tumbling-window chaining or precise event semantics it is design work. Catalogue every trigger and its dependency behaviour before migrating, because a trigger that silently fires differently is a data-timing bug that surfaces as a late or doubled load.

Linked services, connections and the gateway

ADF's linked services become Fabric connections, managed centrally and reusable across items rather than defined per factory, which is cleaner but means credentials and connection objects are re-established in Fabric rather than imported wholesale. The bigger shift is the runtime for reaching data: ADF's self-hosted integration runtime, which many on-premises SAP and SQL Server loads depend on, is replaced in the Fabric world by the on-premises data gateway.

That gateway change matters for anyone pulling from on-premises sources — the connectivity is re-provisioned and re-tested, and the operational ownership of the gateway (who patches it, who monitors it) is re-established. For a cloud-only estate this is minor; for a manufacturer pulling from an on-premises SAP S/4HANA or a plant SQL Server, the gateway migration is one of the more careful parts of the exercise and should be rehearsed against a non-production source first.

The two migration areas that most often bite: tumbling-window trigger semantics, and on-premises connectivity moving from a self-hosted integration runtime to the on-premises data gateway. Rehearse both before touching a production load.

Data flows and pipelines: what maps and what rebuilds

Pipelines and their activities migrate relatively well — the orchestration concepts are shared, and copy activities and control flow look familiar. Data transformation is where the authoring surface changes: ADF's mapping data flows and wrangling data flows give way to Dataflows Gen2 in Fabric, built on the Power Query engine, which is a different authoring model rather than a direct import. Transformation logic is rebuilt on the new surface, not lifted across.

For estates that kept transformation in SQL or notebooks and used ADF mainly for orchestration, the migration is lighter — the heavy logic was never in ADF data flows. For estates that invested in complex mapping data flows, that logic is re-authored in Dataflows Gen2 or moved to Fabric notebooks/Spark, which is an opportunity to simplify but also real work. Inventory where your transformation logic actually lives before estimating the migration.

The cost model changes fundamentally

This is the difference finance will notice. Azure Data Factory bills per activity run, per data-movement volume, and per integration-runtime hour — a granular, usage-based model. Fabric Data Factory consumes Fabric capacity units (CU) from the same shared capacity as every other Fabric workload, so pipeline cost becomes part of the capacity planning rather than a separate per-run line.

Whether that is cheaper depends entirely on workload shape. A heavy, bursty ADF workload may be more economical on dedicated Fabric capacity; a light, intermittent one may be cheaper on ADF's pay-per-run. The real risk is not the headline cost but contention: pipeline runs now compete for the same CUs as Power BI queries and lakehouse jobs, so a heavy overnight load can throttle capacity that interactive reporting needs in the morning. Model the capacity consumption and the timing, not just the sticker price.

Where this breaks

There is no reliable one-click migration. Microsoft provides tooling and guidance, but tumbling-window triggers, complex mapping data flows, self-hosted IR dependencies and custom activities need deliberate rebuilding and testing. Treating the migration as automatic is the single most common way it goes wrong — budget for a proper migration project with a parallel-run period, not a weekend.

Capacity contention is a genuinely new failure mode: in ADF a runaway pipeline cost money; in Fabric it can starve your reporting layer of capacity, so workload scheduling and capacity sizing become operational concerns they were not before. And some ADF capabilities and third-party connectors may not have exact Fabric equivalents yet — check the specific activities and connectors your pipelines use against current Fabric support before committing a date, because a missing connector is a blocker discovered too late.

What to do first

Inventory before you migrate — the estimate lives in the detail, not the headline.

  • Catalogue every pipeline, trigger (and its dependency/backfill behaviour), linked service and data flow, and where transformation logic actually lives
  • Flag the hard parts: tumbling-window triggers, mapping data flows, self-hosted IR / on-premises sources, custom activities
  • Confirm every connector and activity you use has current Fabric support before committing a timeline
  • Model Fabric capacity consumption and run timing, including contention with Power BI and lakehouse workloads
  • Migrate in waves with a parallel-run period and reconciliation, rehearsing the on-premises gateway cutover against a non-production source first

If you are planning an Azure Data Factory to Fabric move, the risk is in the triggers, gateways and capacity model — not the pipelines you can see. Book 30 minutes with Amit for an honest migration assessment of your ADF estate. No slides, no pitch deck, no obligation to proceed.

Free Assessment

Where does your operation sit on the data maturity curve?

8 questions. 3 minutes. You get a scored breakdown across data infrastructure, analytics readiness, and automation potential — with a specific next step for your industry.

Data PlatformMicrosoft FabricAzure Data FactoryMigrationData IntegrationCost

Your Data · Our Technology · Our Automation

Get practical insights every fortnight

Amit writes about Microsoft Fabric, Power BI, AI in operations, and digital transformation for manufacturing and supply chain leaders. Practitioner perspective - no fluff, no vendor spin.

No spam. Unsubscribe any time. Also on Substack.

FAQ

Common questions

Is moving from Azure Data Factory to Fabric Data Factory a lift-and-shift?

No. They share the pipeline engine, so orchestration migrates relatively well, but triggers, linked services and gateways, data flows and the cost model all differ. Tumbling-window triggers, mapping data flows and self-hosted integration runtime dependencies need rebuilding and testing. Plan it as a migration project with a parallel-run period, not a weekend cutover.

What happens to triggers when migrating to Fabric Data Factory?

Schedule triggers map fairly directly to Fabric's native scheduling, but tumbling-window dependency and backfill semantics, and event triggers, do not map one-for-one — Fabric uses native scheduling and event-driven execution via Data Activator and event streams. Trigger logic is re-created and re-tested rather than exported, so catalogue each trigger's behaviour first; a trigger firing differently causes late or doubled loads.

What replaces the self-hosted integration runtime in Fabric?

The on-premises data gateway. ADF's linked services become Fabric connections, and on-premises connectivity (common for SAP S/4HANA and plant SQL Server) moves from the self-hosted integration runtime to the gateway. The connection is re-provisioned and re-tested, and gateway ownership — patching and monitoring — is re-established. For on-premises-heavy estates this is one of the more careful parts of the migration.

How does Fabric Data Factory cost compare to Azure Data Factory?

The model changes. ADF bills per activity run, data-movement volume and integration-runtime hours; Fabric Data Factory consumes Fabric capacity units from shared capacity. Whether it is cheaper depends on workload shape — heavy bursty workloads may suit dedicated capacity, light intermittent ones may suit ADF pay-per-run. The real risk is capacity contention with Power BI and lakehouse workloads, so model consumption and timing, not just price.

Do ADF mapping data flows migrate to Fabric automatically?

No. Mapping and wrangling data flows give way to Dataflows Gen2, built on the Power Query engine — a different authoring surface, so transformation logic is re-authored rather than imported. Estates that kept transformation in SQL or notebooks and used ADF for orchestration migrate more lightly; estates with complex mapping data flows face real re-authoring work, which is also a chance to simplify.

Related FAQs

Questions operations leaders ask

Continue Reading

Related Articles

Data Platform

Microsoft Fabric vs a Legacy BI Stack (SSIS + SSAS + Power BI): The Migration Case

The most common estate I walk into is not a mess. It is an on-premises SQL Server, a set of SSIS packages built between 2014 and 2019, one or two SSAS cubes, and Power BI bolted on the front. It runs. Finance closes on it. The reason I get called is a symptom — the person who wrote the packages left, the overnight batch now finishes at 07:20 and the plant meeting is at 07:30. "It is old" is not a business case.

16 min read

Data Platform

Microsoft Fabric vs SAP Datasphere: Which One Do You Actually Need

The SAP account team says the analytics answer is SAP Datasphere, because that is where the business semantics already live. Two weeks later the Microsoft team says Fabric, because that is where Power BI, the MES extracts and the 3PL feeds already live. Both are internally consistent, and neither mentions the other except to dismiss it. The IT Head is asked to pick, and picks badly — because the two products solve different halves of one problem.

16 min read

Data Platform

The Hidden Costs of a Microsoft Fabric Migration Nobody Tells You About

The awkward conversation happens in month five, not month one. The platform works. The first three reports are live. Then the finance business partner circulates the actual run-rate against the approved business case, and the number is 30–50% over — not because the partner overran, but because six or seven cost lines were never in the case at all. I sell Fabric implementations. This names the costs my own proposals have to cover.

15 min read

Want to see how MDI solves this in your industry? Explore industry solutions

Is this your situation?

A 30-minute working call with Amit. We look at your actual setup, not a template, and you leave with a clear next step.