Sources and connectivity
Keep suitable operational and Azure sources in place. Design supported connections, identities, network paths, gateways, and data access for each workload.
Data platform modernization
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.
Migration scope, compatibility, cost, and timing are workload- and environment-dependent.
Why evaluate Fabric
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
This is a planning map, not a promise that every source feature has a direct or one-click equivalent.
| Azure workload | Potential Fabric destination or approach | Key consideration |
|---|---|---|
| Azure Data Factory pipelines | Fabric Data Factory pipelines | Assess activity, connector, authentication, trigger, integration runtime, and network compatibility. Remediate or redesign unsupported components. |
| ADF Mapping Data Flows | Dataflow Gen2 and supported Mapping Data Flow transforms | Confirm current status, transformation and connector support, authentication, and network requirements. |
| Synapse dedicated SQL pools | Fabric Warehouse | Review SQL behavior, schema, data types, security, workload patterns, and performance; validate results after migration. |
| Synapse serverless SQL | Retain, integrate, or redesign for an appropriate Fabric workload | Review query patterns, data location, SQL behavior, dependencies, and the intended target before selecting a migration path. |
| Synapse Spark pools and notebooks | Fabric Lakehouse and Spark | Review runtime settings, libraries, APIs, authentication, data paths, and job configuration. |
| ADLS Gen2 | OneLake or OneLake shortcuts to ADLS Gen2 | Choose shortcuts or physical migration based on ownership, access, performance, governance, retention, and cost. |
| Azure SQL Database | Retain, integrate, or migrate selected data to Fabric | Select an approach based on application requirements, transaction behavior, SQL compatibility, and analytical needs. |
| Azure Data Explorer / Synapse Data Explorer | Fabric Real-Time Intelligence / Eventhouse | Assess KQL, ingestion, retention, streaming, and feature compatibility for each workload. |
| Power BI reports and semantic models | Power BI in Fabric; Direct Lake where appropriate | Validate DAX, relationships, model size, refresh, security, and Direct Lake guardrails. |
Target architecture
The target design should connect the appropriate Fabric workloads without assuming that every Azure service or data set must move.
Keep suitable operational and Azure sources in place. Design supported connections, identities, network paths, gateways, and data access for each workload.
Use Fabric Data Factory, Dataflow Gen2, or other appropriate patterns for supported ingestion and transformation needs; keep or redesign workloads that do not fit.
Organize Fabric data zones and Delta tables. Choose ADLS Gen2 shortcuts or physical movement dataset by dataset, with clear source ownership and access controls.
Select Lakehouse, Warehouse, Spark, or Real-Time Intelligence according to the data model, transformation, query, and latency requirements.
Connect Power BI semantic models and reports to suitable target data. Evaluate Direct Lake only when its model, security, capacity, and operational requirements fit.
Plan workspace and item access, OneLake data permissions, governance, deployment, monitoring, recovery, capacity management, and support across environments.
Migration strategy
Choose the migration pattern according to compatibility, business value, dependencies, and operating requirements.
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.
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.
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
A controlled lifecycle makes dependencies, assumptions, acceptance criteria, and operational ownership visible before production cutover.
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.
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.
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.
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.
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.
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.
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
Migration decisions should be specific to the source workload, supported migration paths, and target requirements.
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.
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.
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.
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.
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.
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
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.
Capacity, performance, and cost
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.
Savings, performance improvements, and migration duration are not guaranteed; they depend on workload characteristics and implementation.
Risk and validation
Define observable acceptance criteria and prove the target behavior before production cutover.
Migration accelerator
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 offerA Fabric readiness assessment can review BI, ETL, data platform, and data engineering assets to inform compatibility, prioritization, and roadmap decisions.
Any sample scores, workload counts, effort estimates, or waves shown in assessment materials are illustrative—not customer results or project commitments.
Microsoft documentation
Use current Microsoft product documentation to confirm availability, supported scenarios, and limitations during planning.
Frequently asked questions
Answers depend on source artifacts, the target architecture, current Microsoft capabilities, and tenant configuration.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Microsoft documents migration of Mapping Data Flows into Dataflow Gen2 transforms for supported scenarios. Check current status, connector support, transformations, authentication, and network requirements.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
We are an authorized implementation partner of Snowflake, Databricks, Amazon, Automation Anywhere, Denodo, DataDog, New Relic, and Elastic.