Microsoft Fabric Learning Hub
Your Fabric-only learning path: OneLake, Lakehouse, ingestion, notebooks, Warehouse, Real-Time Intelligence, Direct Lake, governance, and Fabric AI. Start with the foundations or choose the modules that match your role.
Pick Your Track
Every module works as a standalone reference, but if you’re following a specific goal, start here instead of reading top to bottom.
What belongs in this Fabric hub?
This child hub organizes Fabric-specific guides into nine modules. Power BI content is included here only where it directly concerns Fabric, such as Direct Lake, Fabric capacity migration, and analytics engineering. General Power BI and wider data-engineering learning remain in Free Learning Resources.
New to Fabric? Follow the modules in order, beginning with the platform overview and a Lakehouse. Experienced readers can use the track selector or module navigation to jump to a relevant guide. These are independent learning resources, not a Microsoft-issued course or a guarantee of exam readiness.
Foundations & OneLake
FoundationUnderstand the Fabric platform, its shared OneLake foundation, Lakehouse storage, and where its workloads fit. Start with the overview, then explore a Lakehouse.
Microsoft Fabric Overview
The definitive guide to the platform’s architecture. Understand OneLake, compute capacities, and the “one copy” principle.
Start Lesson →Fabric Lakehouse Tutorial
Hands-on guide to creating your first Lakehouse. Delta Tables, file shortcuts, and the explorer interface.
Start Lesson →Microsoft Fabric SQL Database
The platform’s transactional database workload — how it differs from Warehouse and Lakehouse, and when to use it.
Start Lesson →OneLake Shortcuts
Reference data across workspaces, ADLS Gen2, S3, and Dataverse without physically copying it.
Start Lesson →Fabric vs. Azure Synapse
A deep architectural comparison, plus the pros, cons, and migration path for existing Azure customers.
Start Lesson →Data Engineering & Ingestion
Data engineeringBuild the Fabric ingestion and transformation path with Dataflow Gen2, pipelines, PySpark notebooks, mirroring, and Fabric-specific dbt workflows.
Dataflow Gen2 Masterclass
Visual ETL. Ingest data using Power Query Online and write it directly to Delta Lake tables.
Start Lesson →Data Pipelines in Fabric
Build enterprise-grade workflows. Schedule notebooks, trigger stored procedures, and monitor run history.
Start Lesson →Transform with Notebooks
Code-first engineering. PySpark syntax, Spark SQL optimization, and library management.
Start Lesson →Data Mirroring Tutorial
Replicate Azure SQL, Cosmos DB, and Snowflake data in near-real-time without building pipelines.
Start Lesson →Native dbt Jobs in Fabric
Run dbt transformations as a first-class, orchestrated job inside Fabric rather than an external tool.
Start Lesson →Fabric Spark Runtime Guide
Review runtime selection and migration considerations. Check Microsoft’s current runtime documentation before changing an existing environment.
Open guide →Fabric Warehouse & Architecture
Architecture & SQLExplore Fabric Warehouse, choose between Warehouse and Lakehouse, and organize Bronze, Silver, and Gold layers within Fabric.
Data Warehousing in Fabric
Build Star Schemas using the serverless SQL engine. DDL, DML, and security patterns.
Start Lesson →Lakehouse vs. Data Warehouse
The decision guide. When to use Spark vs. T-SQL for your Gold layer serving.
Start Lesson →Medallion Architecture in Fabric
Structuring Bronze, Silver, and Gold layers using Fabric-native tools end to end.
Start Lesson →GPU-Accelerated Fabric Data Warehouse
How GPU acceleration changes warehouse performance characteristics for compute-heavy workloads.
Start Lesson →Real-Time Intelligence
Streaming & KQLExplore Fabric Eventstreams, the Real-Time Hub, KQL, and Activator. Use the linked guides to check supported sources, actions, and current feature behavior.
Eventstreams in Fabric
Ingest and route real-time data from IoT Hubs, Kafka, and CDC feeds to KQL databases with no code.
Start Lesson →Fabric Real-Time Hub
The tenant-wide catalog for discovering, subscribing to, and publishing streaming and business events.
Start Lesson →KQL Tutorial for Microsoft Fabric
Kusto Query Language fundamentals — filtering, summarizing, and time-series analysis.
Start Lesson →Microsoft Fabric Data Activator
No-code triggers and Reflex objects that turn detected data patterns into automated alerts and actions.
Start Lesson →Direct Lake & Fabric Analytics
Fabric analyticsFocus on analytics scenarios that depend on Fabric: Direct Lake performance, fallback diagnosis, and migration from Power BI Premium capacity. General DAX and report-authoring lessons belong in the parent hub.
Direct Lake Performance Optimization
V-Order, parquet framing, column cardinality, and avoiding DirectQuery fallback.
Start Lesson →Direct Lake Fallback to DirectQuery — Fix
The full list of what silently triggers a Direct Lake fallback, and how to prevent each one.
Start Lesson →Premium to Fabric Migration
A step-by-step guide to moving legacy P-SKU capacities to the modern F-SKU architecture.
Start Lesson →Security, Governance & Operations
Governance & operationsExplore OneLake access, Fabric governance, capacity management, and production-operating considerations. Check the execution identity and data-access path when applying security guidance.
OneLake Security in Microsoft Fabric
Row, column, and object-level access roles defined once at the OneLake data layer.
Start Lesson →Microsoft Fabric Data Governance Tutorial
Sensitivity labels, Purview integration, and the OneLake Catalog’s Govern tab.
Start Lesson →Microsoft Fabric Capacity Optimization
CU mechanics, throttling stages, smoothing windows, and right-sizing your F-SKU.
Start Lesson →Production Stability Guide
Manage capacity smoothing, avoid throttling, and implement robust CI/CD pipelines.
Start Lesson →Fabric Pricing Calculator
Explore capacity and storage estimates; verify current regional pricing and the calculator assumptions.
Open guide →AI & Data Agents in Fabric
Fabric AIExplore Fabric Data Agents and retrieval-augmented generation using Fabric data. Confirm feature availability, prerequisites, and current limitations in the linked guides and Microsoft documentation.
Microsoft Fabric Data Agent
Build a Q&A agent grounded in your Lakehouse or Warehouse data — setup and configuration.
Start Lesson →Fabric Data Agent Code Interpreter
Extending a Data Agent with code-execution capability for more complex analytical questions.
Start Lesson →Build AI with Fabric RAG
Ground LLMs on your OneLake data to build trustworthy internal chatbots and search tools.
Start Lesson →Fabric Platform Extensions
Advanced explorationExplore Fabric-specific platform and application guides. This focused collection excludes broader Microsoft ecosystem products that are not Fabric learning topics.
Fabric Certification & Interviews
Career preparationFind DP-600 analytics-engineering, DP-700 data-engineering, and Fabric interview preparation. Use Microsoft’s current skills-measured pages as the authority for exam objectives.
DP-600 Exam Guide 2026
Fabric Analytics Engineer Associate — semantic models, DAX, and Direct Lake at enterprise scale.
Start Lesson →DP-700 Exam Guide 2026
Fabric Data Engineer Associate — pipelines, Spark, Lakehouse, and orchestration.
Start Lesson →Microsoft Fabric Interview Questions
The 7-pillar interview question hub — architecture, engineering, warehousing, Power BI, and governance.
Start Lesson →Fabric Data Engineering Interviews
Review data-engineering questions and scenarios within Fabric.
Open guide →Fabric Troubleshooting & Official References
Real projects hit real errors. This vault collects fixes for the most common issues encountered while working through this series, plus links to official documentation for deeper technical reference.
Quick Fixes
Fix Direct Lake Fallback Fix OneLake Shortcut Authorization Fix Spark Shuffle Slowdown Fix Py4JJavaError Saving Delta Tables Fix CSV BOM / Column Not Found Errors Fix Dataflow Gen2 Error 20302Official References
Microsoft Fabric DocumentationThe official source for API references and release notes.
DP-600 Exam DetailsOfficial skills outline for the Fabric Analytics Engineer Associate.
DP-700 Exam DetailsOfficial skills outline for the Fabric Data Engineer Associate.
Delta Lake ProjectDocumentation for the open-source storage layer used by OneLake.
Frequently Asked Questions
How is this different from Free Learning Resources?
Free Learning Resources is the multi-topic parent hub for Fabric, Power BI, and wider data engineering. This page is its focused Microsoft Fabric child hub.
Do I need prior Azure experience?
Begin with Module 1 if you are new to Fabric. SQL or Python familiarity helps with later technical lessons; check each guide’s prerequisites before starting.
Which certification resources belong here?
The Fabric hub includes DP-600, DP-700, and Fabric interviews. General Power BI and PL-300 preparation are available from the parent learning hub. Verify current exam objectives with Microsoft.
Are hands-on exercises free to run?
Reading a learning guide and running cloud resources are different things. Fabric exercises need appropriate tenant access, capacity, and permissions. Trial eligibility and limits apply; paid capacity and related services can incur charges.
How should I use the advanced modules?
Start with the foundations, then choose modules relevant to your role. Confirm current feature support and runtime compatibility in the individual guide and Microsoft documentation before production use.