Microsoft Fabric
The unified analytics platform - GA since 2023, now the default
OneLake
Lakehouse
Power BI Native
Copilot AI
Real-time Analytics
Data Activator
Azure Synapse
Enterprise analytics service - evolving role
Dedicated SQL
Serverless SQL
Apache Spark
Data Explorer
Pipelines
Synapse to Fabric Migration Path
Microsoft is positioning Fabric as the successor to Synapse workloads. While Synapse is being folded into Fabric (with a guided migration path),
new investments focus on Fabric capabilities. Key migrations include: Synapse Data Warehouse to Fabric Warehouse,
Synapse Spark to Fabric Spark, and Synapse Pipelines to Fabric Data Factory.
1
Assess Workloads
2
Pilot in Fabric
3
Migrate Data
4
Retire Synapse
Feature Comparison
Microsoft Fabric
- Unified SaaS platform (single pane of glass)
- OneLake - single storage layer (Delta format)
- Capacity-based pricing (F-SKU)
- Power BI natively integrated
- Copilot AI assistance built-in
- Real-time Analytics (KQL)
- Data Activator for alerts
- Shortcuts to external data
- Mirroring for operational databases
- Unified governance with Purview
Azure Synapse Analytics
- PaaS with multiple components
- Uses ADLS Gen2 for storage
- DWU/Spark vCore pricing
- Power BI integration (separate)
- No built-in AI assistance
- Data Explorer (Kusto) pool
- Manual alerting setup
- External tables and linked services
- Synapse Link for Cosmos DB
- Purview integration available
Microsoft Fabric Workloads
Data Factory
ETL/ELT pipelines
Lakehouse
Delta Lake storage
Warehouse
SQL analytics
Real-time Analytics
KQL queries
Data Science
ML experiments
Power BI
Visualization
Data Activator
Alerts & actions
Eventstream
Event processing
Evolution Timeline
November 2019
Azure Synapse Analytics Announced
Unified analytics combining SQL DW, Spark, and pipelines at Ignite 2019
December 2020
Synapse GA
General availability with Studio workspace, SQL and Spark pools
2021-2022
Synapse Enhancements
Serverless SQL, Data Explorer, Synapse Link expansions
May 2023
Microsoft Fabric Announced
Preview at Build 2023 - unified SaaS analytics platform
November 2023
Microsoft Fabric GA
General availability at Ignite 2023 with OneLake and Copilot
2024-2025
Fabric Expansion
Mirroring, more connectors, enhanced Copilot, workload separation
2026
Synapse Migration
Synapse-to-Fabric migration tools shipped; Synapse now on a retirement path