Data platform modernization

Azure to Microsoft Fabric Migration Services

Modernize your Azure data estate with a migration plan built around your workloads—not a one-size-fits-all lift and shift.

Assess Azure Synapse Analytics, Azure Data Factory, Azure SQL, ADLS Gen2, Spark, and Power BI workloads; identify dependencies and compatibility risks; then plan a controlled path to Microsoft Fabric.

The goal is to preserve business logic, data quality, security, reporting continuity, and operations while evaluating where Fabric-native capabilities fit.

Explore Pulse Convert

Migration scope, compatibility, cost, and timing are workload- and environment-dependent.

Why evaluate Fabric

A modernization opportunity—not an automatic cost or service replacement

Fabric integrates data engineering, integration, warehousing, data science, real-time analytics, and Power BI experiences. Whether it is a fit depends on workload requirements and the target operating model.

Bring selected analytics workloads into a more integrated platform.

Reduce unnecessary data copies through supported shortcuts and shared formats.

Modernize integration, engineering, and reporting patterns in deliberate stages.

Connect lakehouse, warehouse, real-time, and Power BI workflows where suitable.

Establish clear workspace, item, and data-access controls.

Measure capacity, storage, networking, licensing, and operating requirements before sizing.

Fabric does not automatically reduce costs or eliminate infrastructure, networking, security, and operational responsibilities. Establish a representative baseline and compare the target design before making a business case.

Workload mapping

Azure services and potential Fabric paths

This is a planning map, not a promise that every source feature has a direct or one-click equivalent.

Azure workloadPotential Fabric destination or approachKey consideration
Azure Data Factory pipelinesFabric Data Factory pipelinesAssess activity, connector, authentication, trigger, integration runtime, and network compatibility. Remediate or redesign unsupported components.
ADF Mapping Data FlowsDataflow Gen2 and supported Mapping Data Flow transformsConfirm current status, transformation and connector support, authentication, and network requirements.
Synapse dedicated SQL poolsFabric WarehouseReview SQL behavior, schema, data types, security, workload patterns, and performance; validate results after migration.
Synapse serverless SQLRetain, integrate, or redesign for an appropriate Fabric workloadReview query patterns, data location, SQL behavior, dependencies, and the intended target before selecting a migration path.
Synapse Spark pools and notebooksFabric Lakehouse and SparkReview runtime settings, libraries, APIs, authentication, data paths, and job configuration.
ADLS Gen2OneLake or OneLake shortcuts to ADLS Gen2Choose shortcuts or physical migration based on ownership, access, performance, governance, retention, and cost.
Azure SQL DatabaseRetain, integrate, or migrate selected data to FabricSelect an approach based on application requirements, transaction behavior, SQL compatibility, and analytical needs.
Azure Data Explorer / Synapse Data ExplorerFabric Real-Time Intelligence / EventhouseAssess KQL, ingestion, retention, streaming, and feature compatibility for each workload.
Power BI reports and semantic modelsPower BI in Fabric; Direct Lake where appropriateValidate DAX, relationships, model size, refresh, security, and Direct Lake guardrails.

Target architecture

Design around source systems, data products, and consumers

The target design should connect the appropriate Fabric workloads without assuming that every Azure service or data set must move.

Sources and connectivity

Keep suitable operational and Azure sources in place. Design supported connections, identities, network paths, gateways, and data access for each workload.

Integration and orchestration

Use Fabric Data Factory, Dataflow Gen2, or other appropriate patterns for supported ingestion and transformation needs; keep or redesign workloads that do not fit.

OneLake data foundation

Organize Fabric data zones and Delta tables. Choose ADLS Gen2 shortcuts or physical movement dataset by dataset, with clear source ownership and access controls.

Engineering and serving

Select Lakehouse, Warehouse, Spark, or Real-Time Intelligence according to the data model, transformation, query, and latency requirements.

Analytics and consumption

Connect Power BI semantic models and reports to suitable target data. Evaluate Direct Lake only when its model, security, capacity, and operational requirements fit.

Cross-cutting operations

Plan workspace and item access, OneLake data permissions, governance, deployment, monitoring, recovery, capacity management, and support across environments.

Migration strategy

Lift and shift, phased modernization, or hybrid

Choose the migration pattern according to compatibility, business value, dependencies, and operating requirements.

Lift and shift selected workloads

Use when a source workload has a suitable supported migration path and preserving its current behavior is the priority. Compatibility, dependencies, security, and performance still require assessment and validation.

Phased modernization

Move workloads in business-aligned waves, using the migration to simplify selected data flows, models, and operations. Prioritize by readiness, value, dependency risk, and impact rather than service name alone.

Hybrid Azure and Fabric

Keep selected services or data in Azure while suitable analytics workloads move to Fabric. Define ownership, identity, network access, monitoring, cost visibility, and criteria for long-term coexistence or retirement.

Seven-phase methodology

From inventory to continuous improvement

A controlled lifecycle makes dependencies, assumptions, acceptance criteria, and operational ownership visible before production cutover.

1. Inventory and assessment

Catalog ADF pipelines and dependencies, Synapse SQL and Spark assets, Azure SQL databases, ADLS accounts and data, Power BI models, real-time workloads, identities, networking, monitoring, and operational owners. Baseline volumes, run times, service levels, and costs.

Typical output: Workload inventory, dependency map, compatibility and complexity register, baseline, and initial risks.

2. Target architecture and roadmap

Select Fabric components for each workload; decide where ADLS shortcuts or physical movement fit; define workspaces, environments, security, data zones, capacity assumptions, migration waves, and acceptance criteria.

Typical output: Target architecture, source-to-target mapping, security plan, capacity assumptions, and migration wave plan.

3. Fabric foundation and pilot

Configure tenant and workspace settings, development/test/production environments, identities, connections, OneLake, deployment processes, and monitoring. Pilot a representative workload and test the proposed patterns.

Typical output: Configured Fabric foundation, representative pilot, tested patterns, and refined estimates and risks.

4. Data, pipeline, and warehouse migration

Migrate approved workloads in manageable waves. Rebuild or migrate eligible pipelines, remediate connections, migrate supported data flows, SQL objects and data, refactor Spark notebooks, and establish shortcuts or move data as designed.

Typical output: Migrated Fabric artifacts, updated code and configuration, migration logs, and a remediation register.

5. Validation and performance testing

Reconcile row counts, schemas, aggregates, business measures, incremental loads, SQL results, pipeline behavior, reports, security, and representative performance. Agree acceptance criteria before migration and record business-owner sign-off.

Typical output: Source-to-target validation evidence, performance baseline, defect register, and business acceptance.

6. Cutover and production transition

Confirm readiness, run final loads, reconcile source and target, redirect approved consumers and schedules, monitor production, retain recovery options, and hand over runbooks and support ownership.

Typical output: Cutover record, operational runbooks, support plan, and approved coexistence or source-retirement plan.

7. Optimization and continuous improvement

Review measured capacity utilization, throttling, pipeline and Spark behavior, warehouse queries, shortcut usage, semantic models, security, governance, and actual costs. Use findings to tune the platform and plan further waves.

Typical output: Optimization backlog, capacity and cost review, governance review, and next-wave roadmap.

Technical considerations

Plan each Azure workload on its own merits

Migration decisions should be specific to the source workload, supported migration paths, and target requirements.

Azure Data Factory

Inventory pipelines, activities, linked services, datasets, parameters, triggers, integration runtimes, Mapping Data Flows, custom code, and external dependencies. Microsoft provides assessment-led migration guidance for supported pipelines; compatibility depends on activity, connector, authentication, and networking. Bringing an Azure Data Factory item into a Fabric workspace can unify management in some scenarios while execution may still run in Azure—it is not the same as migrating execution to Fabric Data Factory.

Synapse dedicated SQL pools

Assess schemas, tables, data types, T-SQL, stored procedures, functions, security, workload patterns, and consumers. Microsoft migration guidance and the Fabric Migration Assistant can support planning, but generated or migrated artifacts still need remediation, data reconciliation, query testing, and performance validation.

Synapse Spark

Inventory notebooks, Spark pools, libraries, configurations, jobs, data paths, authentication, and dependencies. Test and update code and environment settings for the intended Fabric Spark runtime rather than assuming notebooks will run unchanged.

ADLS Gen2 and OneLake

A OneLake shortcut references supported external data without first copying it; the source remains in ADLS and its availability, identity, ACLs, and network requirements continue to matter. Physical migration may be more appropriate for other ownership, performance, governance, retention, or cost requirements.

Power BI and Direct Lake

Review reports, semantic models, gateways, refresh patterns, DAX, relationships, data types, row-level security, and downstream consumers. Direct Lake reads Delta tables in OneLake and may be suitable for some models, but capacity, file and row-group guardrails, security, model design, refresh/framing, and possible DirectQuery fallback affect behavior. It is not a universal performance guarantee.

Azure SQL and real-time analytics

Decide whether Azure SQL should remain, integrate with Fabric, or provide selected data to an analytical target; account for transactional requirements. For Azure Data Explorer or Synapse Data Explorer, assess the appropriate Fabric Real-Time Intelligence or Eventhouse path, including KQL, ingestion, retention, and streaming.

Shortcuts are not data copies. A shortcut provides a logical reference to supported external data; the source remains in place and its access, availability, and governance remain part of the design.

Security and governance

Design access across control and data planes

Fabric workspace and item permissions, OneLake security, Microsoft Entra identities, source permissions, networking, and audit controls need to be assessed together. Validate the intended access paths rather than assuming a one-to-one Azure RBAC conversion.

  • Map Microsoft Entra identities, service principals, managed identities, credentials, and application access.
  • Design Fabric workspace and item permissions separately from OneLake data permissions at supported scopes.
  • Review Azure resource RBAC, ADLS ACLs, source permissions, network controls, and shortcut access behavior.
  • Plan least privilege, secret handling, key rotation, audit, data classification, retention, and regulatory controls.
  • Test access through each intended workload and identity; do not assume OneLake automatically replaces Azure RBAC.
  • Include Microsoft Purview and Fabric governance capabilities in the wider governance model where appropriate.

Capacity, performance, and cost

Model real workloads, not generic savings

Fabric capacity, storage, networking, licensing, parallel operation, and services that remain in Azure all affect the economics. Baseline representative workloads and review current Microsoft pricing and capacity options before sizing.

  • Workload count, data volume and growth, complexity, remediation, and migration tooling.
  • Fabric capacity SKU, utilization, concurrency, throttling, and workload scheduling.
  • OneLake storage, retained ADLS data, shortcuts, duplicated staging, and data movement.
  • Networking, regional placement, licenses, support, and services that remain in Azure.
  • Parallel operation, testing, cutover constraints, and ongoing operational effort.

Savings, performance improvements, and migration duration are not guaranteed; they depend on workload characteristics and implementation.

Risk and validation

Reduce migration risk with explicit checks

Define observable acceptance criteria and prove the target behavior before production cutover.

Common risks to assess

  • Assuming every ADF activity, Synapse feature, Spark dependency, or SQL object has a direct equivalent.
  • Treating an Azure Data Factory item managed in a Fabric workspace as Fabric Data Factory execution.
  • Confusing a OneLake shortcut with a physical data migration or overlooking source ACL and network dependencies.
  • Mapping Azure RBAC directly to Fabric workspace roles without designing OneLake data permissions.
  • Assuming Direct Lake always performs better or cannot fall back to DirectQuery.
  • Changing pipelines or models without testing incremental loads, retries, late-arriving data, and business measures.
  • Estimating savings or timelines before measuring representative workloads and capacity requirements.
  • Retiring source services before reconciliation, consumer cutover, business approval, and recovery planning.

Validation checklist

  • Compare row counts, record totals, schema, nulls, duplicates, and referential integrity.
  • Reconcile business aggregates, measures, SQL results, historical completeness, and incremental behavior.
  • Test pipeline schedules, dependencies, triggers, retries, alerts, restart, and failure scenarios.
  • Benchmark representative warehouse queries, Spark jobs, and data refresh behavior.
  • Compare Power BI visuals, DAX measures, security roles, refresh, and Direct Lake behavior when used.
  • Record agreed acceptance criteria, defects, remediation, and business-owner approval.

Migration accelerator

Pulse Convert for Azure and Fabric workloads

Pulse Convert is listed on Microsoft Marketplace as Azure To Microsoft Fabric Migration Tool. The Marketplace description positions it as an accelerator for ADF and Synapse migration assistance, including pipeline and schema analysis, connection mapping, suggested architecture changes, and output comparison workflows.

These are publisher-described capabilities. Confirm supported artifact types, conversion scope, product limits, licensing, and validation methods with the publisher. Use the accelerator within a governed process—not as a replacement for discovery, architecture decisions, security review, testing, or business acceptance.

View the Microsoft Marketplace offer

Readiness assessment scope

A Fabric readiness assessment can review BI, ETL, data platform, and data engineering assets to inform compatibility, prioritization, and roadmap decisions.

  • ADF pipeline support and remediation needs.
  • Synapse SQL and Spark complexity and dependencies.
  • ADLS shortcut versus physical migration candidates.
  • Power BI model, report, and security validation scope.
  • Target architecture, waves, capacity assumptions, and risks.

Any sample scores, workload counts, effort estimates, or waves shown in assessment materials are illustrative—not customer results or project commitments.

Frequently asked questions

Azure to Microsoft Fabric migration FAQs

Answers depend on source artifacts, the target architecture, current Microsoft capabilities, and tenant configuration.

What is Azure to Microsoft Fabric migration?

It is the process of assessing and transitioning selected Azure data, integration, warehouse, Spark, and analytics workloads to appropriate Microsoft Fabric services. Scope may include data, pipelines, SQL objects, notebooks, semantic models, security, and operational processes.

Why migrate from Azure to Microsoft Fabric?

Organizations may choose Fabric to bring data integration, engineering, warehousing, data science, real-time analytics, and Power BI into a more integrated analytics platform. The value depends on workload fit, architecture, governance, cost, and operating requirements.

Does Microsoft Fabric replace Azure Synapse Analytics?

Fabric provides potential targets for selected Synapse workloads, including Data Warehouse, Lakehouse, Spark, Data Factory, and Real-Time Intelligence. Not every Synapse feature has a direct equivalent, so assess components and dependencies individually.

Can Azure Data Factory pipelines be migrated to Fabric Data Factory?

Microsoft provides an assessment-led migration experience for supported ADF pipelines. Compatibility varies by activity, connector, connection, authentication, and network configuration. Some pipelines need remediation or redesign.

Can I run Azure Data Factory inside a Fabric workspace?

Microsoft supports bringing an Azure Data Factory item into a Fabric workspace in certain scenarios. Management may be unified while pipeline execution and integration runtimes still run in Azure; this is not the same as migrating to Fabric Data Factory.

Do I need to move all ADLS Gen2 data to OneLake?

No. OneLake shortcuts can reference supported ADLS Gen2 paths without first copying all the data. Choose shortcuts or physical migration based on data ownership, performance, access, governance, retention, and cost.

What are OneLake shortcuts?

OneLake shortcuts are references to data stored in another location, such as ADLS Gen2. They let Fabric items access external data through a logical path; source permissions and availability still matter.

Can Azure Synapse dedicated SQL pools migrate to Fabric Warehouse?

Microsoft provides migration planning guidance and a Fabric Migration Assistant for Data Warehouse to support dedicated SQL pool migration. Schema, data, SQL code, data types, security, and performance still require assessment and validation.

Does Synapse SQL code work unchanged in Fabric Warehouse?

Not necessarily. T-SQL compatibility and behavior differ across platforms. Review stored procedures, functions, data types, unsupported features, query patterns, and performance assumptions before cutover.

Can Azure Synapse Spark notebooks migrate to Fabric Spark?

Migration paths exist for Synapse Spark notebooks and related artifacts, but runtime settings, libraries, APIs, authentication, storage paths, and job configurations may need changes. Check Microsoft's current guidance for each artifact type.

Can I migrate Azure Synapse Mapping Data Flows?

Microsoft documents migration of Mapping Data Flows into Dataflow Gen2 transforms for supported scenarios. Check current status, connector support, transformations, authentication, and network requirements.

What is the difference between a Lakehouse and a Warehouse in Fabric?

A Lakehouse suits data-lake and Spark-oriented engineering patterns, including files and Delta tables. A Warehouse provides a SQL-based analytical warehouse experience. Choose based on workload, data model, users, and performance requirements.

What is Direct Lake in Microsoft Fabric?

Direct Lake is a Power BI semantic model storage mode that reads Delta tables in OneLake. It can reduce the need to import data into a semantic model, but capacity, file, row-group, security, and model-design considerations apply; it does not guarantee better performance.

Will my DAX measures continue to work after migration?

They may continue to work, but the model, relationships, storage mode, data types, security, and query behavior can change. Validate important measures and reports against representative business scenarios.

Can Power BI reports be migrated without downtime?

Some transitions can be performed with limited disruption through parallel validation and controlled cutover. A zero-downtime guarantee should not be assumed; the approach depends on dependencies, refresh schedules, source availability, and business requirements.

How is security handled in Microsoft Fabric?

Fabric uses workspace and item permissions for management access and OneLake security for data access at supported scopes. Microsoft Entra identities, source ACLs, network controls, and audit requirements also need review and testing.

Does OneLake automatically replace Azure RBAC?

No. OneLake security and Fabric workspace/item permissions are distinct from Azure resource RBAC. Map existing Azure roles, managed identities, service principals, storage ACLs, and application permissions to the target architecture.

Can Fabric access data that remains in Azure?

Yes. Supported OneLake shortcuts can reference ADLS Gen2 data, and other integration patterns can connect Fabric workloads to Azure services. The method depends on source type, networking, identity, and workload requirements.

How much does Azure-to-Fabric migration cost?

Cost depends on data volume, workload count and complexity, remediation, integration, testing, parallel operation, capacity, storage, networking, licensing, and support. A workload assessment and capacity model are needed for a credible estimate.

Will migrating to Fabric reduce Azure costs?

It may reduce or consolidate selected costs, but savings are not guaranteed. Compare current Azure consumption with projected Fabric capacity, storage, networking, remaining Azure services, licensing, and migration costs using representative workloads.

How is Microsoft Fabric capacity priced?

Fabric capacity uses capacity units and supports pay-as-you-go and reservation options, subject to current SKU and regional terms. Storage, networking, licensing, and other services may be billed separately; check current Microsoft pricing.

Can I use a Fabric trial for migration testing?

Microsoft offers Fabric trials in eligible regions and tenants, subject to current terms. Confirm capacity, feature availability, duration, and limitations before using one for a migration pilot.

What is Pulse Convert?

Pulse Convert is the migration accelerator referenced by Office Solution AI Labs and listed on Microsoft Marketplace as Azure To Microsoft Fabric Migration Tool. The Marketplace description positions it for ADF and Synapse migration assistance; confirm current support and limits with the publisher.

Does Pulse Convert automatically migrate every ADF and Synapse workload?

No universal support claim should be assumed. Artifact compatibility varies, and some components need review, remediation, or redesign. Request a demonstration using representative artifacts and review output before production planning.

How do you validate data after migration?

Validation can include row counts, aggregates, business metrics, schema comparisons, SQL results, incremental load behavior, pipeline outcomes, report measures, and security tests. Agree acceptance criteria before migration begins.

How long does an Azure-to-Fabric migration take?

The timeline depends on workload count, complexity, dependencies, data volume, compatibility, security review, testing, and cutover constraints. A representative pilot and inventory provide a more reliable estimate than a generic duration claim.

Can Azure and Fabric run together during migration?

Yes. A hybrid period can allow selected workloads to remain in Azure while others move to Fabric. Define ownership for data access, identity, monitoring, cost, and eventual retirement or long-term coexistence.

Should we migrate everything at once?

A phased migration is often easier to validate and govern. Prioritize workloads by business value, readiness, complexity, dependency risk, and operational impact. Use a big-bang approach only when architecture and business constraints justify it.

What happens to existing Azure services after migration?

Some services may be retired while others remain for application, integration, storage, or operational requirements. Decommission only after dependencies are removed, data is reconciled, consumers are redirected, and owners approve retirement.

What should be included in a Fabric migration assessment?

Include a workload inventory, dependency map, compatibility review, data and performance baseline, security and networking analysis, target architecture, migration waves, capacity assumptions, risks, and acceptance criteria.

Plan your next step

Start with a workload-level Azure to Fabric assessment

Discuss your Azure data estate, migration goals, dependencies, and constraints with Office Solution AI Labs. Scope, timelines, and cost are determined through assessment.

You can also review data engineering services.

Advance Analytics of next generation

We are an authorized implementation partner of Snowflake, Databricks, Amazon, Automation Anywhere, Denodo, DataDog, New Relic, and Elastic.

Copyrights © 2026 Office Solution AI Labs