Every Microsoft Fabric item, with a guide.
Filter by workload, search by name, or browse the catalog. Each guide covers what the item is, when to use it, an accelerator-driven walkthrough, and the pitfalls we see most often.
Lakehouse
Delta-Parquet tables and files on OneLake. The medallion architecture starts here. Bonus: free SQL endpoint, Direct Lake-ready.
Read guide Data WarehouseWarehouse
T-SQL warehouse with multi-table ACID over open Delta storage. Best for star schemas and BI-aligned models.
Read guide DatabasesSQL Database
Operational, Azure-SQL-style database in Fabric. Auto-mirrored to OneLake so OLTP and analytics share one copy.
Read guide Data FactoryData Factory
200+ connectors. Pipelines for activity-based orchestration, Dataflows Gen2 for low-code transformation, Copy Job for high-volume ingest.
Read guide Data EngineeringNotebooks
Interactive Spark and T-SQL development. Python, Scala, R, SQL — versioned with Git integration and reusable environments.
Read guide Data EngineeringData Engineering
Spark pools, runtime environments, Spark Job Definitions, autoscale, and the patterns that keep notebooks production-ready.
Read guide Data ScienceData Science
Notebooks, experiments, model registry, AutoML, and the foundation for Data Agents and predictive workloads.
Read guide Power BIPower BI
Reports, dashboards, paginated reports, and the deployment pipelines that promote them through dev/test/prod.
Read guide Power BISemantic Models
The reusable, governed metric layer. DAX patterns, relationships, RLS/OLS, and Direct Lake for zero-copy query on OneLake.
Read guide Real-TimeReal-Time Intelligence
The umbrella for streaming: Eventhouse, Eventstream, KQL DB, Real-Time Dashboards, Activator — and how they snap together.
Read guide Real-TimeEventhouse
The streaming + time-series workspace. Holds KQL databases optimized for billions of events, IoT, and append-only telemetry.
Read guide Real-TimeEventstream
No-code stream processing. Pull from Event Hubs, Kafka, CDC sources; transform inline; route to multiple destinations.
Read guide Real-TimeKQL Database
Native Kusto database for high-cardinality, append-only, time-series data. Materialized views, update policies, ML functions built-in.
Read guide Real-TimeReal-Time Dashboards
Sub-second dashboards over Eventhouse and KQL DB. Auto-refresh, parameters, drill-down — operations-room-ready.
Read guide Real-TimeActivator
Detect conditions in your data and trigger Teams alerts, Power Automate flows, Fabric pipelines, or Operations Agents.
Read guide Data ScienceData Agents GA
Conversational, governed Q&A over lakehouses, warehouses, semantic models, KQL, and ontologies. Read-only by design.
Read guide Fabric IQOperations Agents Preview
Autonomous, ontology-grounded agents that monitor live streams and take or recommend actions through Activator and Power Automate.
Read guide Fabric IQFabric IQ Preview
Ontologies, plans, Fabric Graph, and the agent runtime. The semantic ground beneath governed AI.
Read guide Fabric IQCopilot in Fabric
Generative AI inside every workload — DAX, Spark, KQL, T-SQL, Dataflow M, and report authoring. Tenant settings, prompt patterns, and governance.
Read guide PlatformOneLake
The single logical lake under every Fabric workload. Open Delta-Parquet, one copy of data, governed by Microsoft Purview.
Read guide PlatformShortcuts
Reference data in place across OneLake, ADLS Gen2, Amazon S3, Dataverse, and Google Cloud Storage — no copy, no movement.
Read guide PlatformMirroring
Continuously replicate Azure SQL, Cosmos, Snowflake, or Databricks into OneLake — no ETL, governed and auto-incremental.
Read guide PlatformDomains
Logical groupings of workspaces — organize Fabric by line of business or data product, with domain-level ownership and policies.
Read guideDon't see your scenario?
Most of our work involves combining items from this catalog. Tell us what you're trying to do and we'll show you the shortest path.