Every Microsoft Fabric Feature, Explained
A living catalog of 89 Microsoft Fabric capabilities across 11 catalog tabs: what each is, when to use it, when to skip it, and its GA or preview month.
A structured rubric for assessing Microsoft Fabric operational maturity. Six domains, five levels, and an interactive dashboard to score your deployment and surface prioritized gaps.
This is a maturity model for Microsoft Fabric production operations: six domains, each scored from Level 1 (Ad Hoc) to Level 5 (Optimized), for a composite of 6 to 30. The domains are Environment Architecture, Deployment Automation, Testing Frameworks, Data Quality Observability, Capacity Governance, and AI-Readiness.
My working hypothesis is that most enterprises land at 8 to 12, early Level 2. That range comes from pattern observation across engagements, not from a survey, so treat it as a starting reference rather than a benchmark. The hardest move is Level 2 to Level 3: the pipelines work, so leadership assumes the platform is mature, while the missing standardization quietly piles up risk.
Score your own deployment with the interactive assessment below. You get a radar chart, composite score, and gap-ranked recommendations. Fix any Level 1 domains first.
Most Fabric deployments plateau. Teams stand up lakehouses, build pipelines, connect Power BI, and declare victory. Six months later they are debugging failed refreshes at 2 AM while AI initiatives stall. Fabric gives you the primitives; this framework measures whether you have the practices.
Rubric version V3.1: the V3 re-level was published 2026-08-25 with platform capabilities verified against Microsoft Learn on that date, and one status tag was corrected 2026-09-15. See Model Version History for what changed and why.
The CMM/CMMI maturity model has structured software process improvement since the 1980s. The same approach applied to data platform operations fills a gap most teams don't know they have, for three reasons:
Capabilities are not outcomes. Having Git integration available and having source-controlled deployments with automated rollback are different things entirely.
The domains are interdependent. You cannot achieve reliable AI-Readiness without Data Quality Observability, or trust your deployments without Testing Frameworks. Advancing one while ignoring another creates a platform that looks mature from one angle and fails from another.
Without assessment, you optimize locally. Prioritization defaults to whatever broke last. A maturity assessment gives you an objective view: "We're L4 on Deployment but L1 on Capacity Governance. That's where the next incident is coming from."
Each domain is scored independently from Level 1 to Level 5. The composite (sum of all six) ranges from 6 to 30. Levels 4 and 5 represent leading-edge practice.
The 8 to 12 baseline used throughout this page, including the dashed reference ring on your radar chart, is a hypothesis. It reflects what I have seen across engagements, and no published dataset backs it. It is there to give a lone score some context, and if your own measurements disagree, trust your measurements.
| Level | Name | Description | Signal |
|---|---|---|---|
| L1 | Ad Hoc | Reactive, no standard process. Success depends on individual heroics. | Single workspace, no Git, manual everything |
| L2 | Emerging | Basic process established. Outcomes repeatable within teams. | Dev/prod separated, basic pipelines, partial monitoring |
| L3 | Defined | Standardized and documented organization-wide. | Git-connected workspaces, CI/CD with fabric-cicd, quality assertions in pipelines |
| L4 | Managed | Quantitatively managed with metrics and SLAs. | Validated deployments, quality scorecards, capacity optimization |
| L5 | Optimized | Continuous improvement driven by data. | Progressive rollout, ML-driven quality, autonomous AI integration |
The most dangerous place is between L2 and L3. Your team has working pipelines, so leadership assumes maturity. But without standardization, every new use case reinvents the wheel and technical debt compounds silently until something breaks publicly.
Each domain covers a distinct operational surface. The assessment tool below has full level descriptions, evidence markers, and business risk for each; this section summarizes the key concerns.
Maturity climbs from a single shared workspace where developers edit production directly (L1), to Git-connected workspaces with branching, service principals (now GA for the Git REST APIs), parameter.yml parameterization, and OneLake security roles that have been scoped rather than left at the shipped DefaultReader (L3), up to self-service environment provisioning with continuous drift detection (L5).
Where teams stall
Most teams plateau at L2 (dev/prod separation). The L3 jump needs Git, service principals, and parameterization. Skip parameterization and hardcoded lakehouse references break on every promotion.
Maturity climbs from editing directly in production (L1), to fabric-cicd with PR-gated merges and runtime configuration via the Variable Library (GA, Sep 2025) at L3, up to progressive rollout with canary validation (L5, still aspirational given Fabric's current architecture).
Where teams stall
Built-in deployment pipelines (L2) are easy, but manual, unvalidated, and lacking dependency ordering. L3 means adopting fabric-cicd and authoring real pipelines. Most teams defer it because "the button works."
Maturity climbs from manual visual inspection (L1), to multi-engine tests covering DAX measures (Semantic Link or XMLA), pipeline integration, and semantic model integrity (L3), up to AI-assisted test generation and mutation testing (L5).
Where teams stall
Testing is where most teams have zero investment. They ship untested notebooks because "the data looks right", until a source schema changes silently and the pipeline produces wrong numbers for a week before anyone notices.
Maturity climbs from discovering bad data when users report wrong numbers (L1), to pipeline-embedded quality assertions and per-table freshness SLAs (L3), up to ML anomaly detection with Purview quality scores and auto-remediation (L5).
Where teams stall
Teams know when a pipeline fails, not when it succeeds with bad data. A source sending 50% fewer records triggers no alert at L1 or L2. Start with the freshness SLA, then layer in completeness and accuracy.
Maturity climbs from a fixed SKU with no monitoring (L1), to CU attribution, throttle alerts, and documented smoothing behavior (interactive 5 to 64 minutes, background 24 hours) with a chargeback model (L3), up to tuned per-workspace surge thresholds, delivered chargeback, and a deliberate Spark billing model at L4, then predictive scaling validated against outcomes and FinOps cost-per-value tracking (L5).
Where teams stall
The Capacity Metrics app is installed but reviewed quarterly (L2). Nobody links utilization to scheduling, so an overnight Spark job collides with the morning refresh burst and everyone blames "the platform" instead of the scheduling gap.
Maturity climbs from semantic models with no measure descriptions where Copilot (F2+ SKUs) underperforms (L1), to 100% measure-description coverage with synonyms and enforced naming (L3), up to autonomous agents navigating models with continuous metadata sync (L5).
Where teams stall
Teams pay for Copilot but get poor results because semantic models lack measure descriptions, readable naming, and glossary links. AI-Readiness is a metadata problem: the fix is enriching models, not waiting for better AI.
How to use this assessment
Click a domain to expand it, review the five levels, and select the one matching your current state. The radar chart and recommendations update live. Your progress is saved automatically.
Two rules before you score: a capability an admin can switch on alone is not by itself an L4 or L5 signal, and a preview feature is a directional signal rather than scoring evidence.
The dashboard maps your composite to a maturity band (6 to 10 Ad Hoc, 11 to 15 Emerging, 16 to 20 Defined, 21 to 25 Managed, 26 to 30 Optimized) and lists priority actions automatically. Below 16, fix environment separation, Git, and deployment automation first. Above 20, shift to testing depth, capacity governance, and AI-readiness.
A balanced radar (all six domains within one level of each other) means even progress. Healthy.
A spiked radar reveals structural risk:
Work gaps in this order:
The goal is not L5 everywhere. Consistent L3 to L4 across all six domains beats L5 in two dimensions and L1 in the rest.
The rubric is versioned separately from this page. The updated date at the top versions the article; the table below versions the model, so a score recorded against an earlier version can be compared with the rubric that produced it.
| Version | Date published | What changed | Thresholds moved |
|---|---|---|---|
| V1 | 2026-04-14 | Initial publication. Six domains, five levels, 30 cells, interactive scoring. | Baseline |
| V2 | 2026-06-17 | Platform currency pass. Nine cells gained mentions of newly shipped Fabric capabilities. | None |
| V3 | 2026-08-25 | Corrective re-level. Status tags dated, composite baseline restated as a hypothesis. | OneLake security D1 L4 to L3; Autoscale Billing for Spark D5 L5 to L4; capacity overage out of D5 L4 |
| V3.1 | 2026-09-15 | Tag correction. Fabric Graph reached GA in June 2026 and the Ontology item has been preview since November 2025 (both per the Learn whats-new archive); the D6 L4 cell and the revisit note had Graph as preview and the ontology dated August 2026. | None |
Scores taken against V1 or V2 may read lower under V3 in Domains 1 and 5 without anything in your deployment having changed. Re-score rather than adjusting old numbers.
This assessment is a starting point, not a report card. Run it as a team exercise: have each member score independently, then compare. The disagreements matter more than the scores. Where people disagree on the current level, you've found a blind spot.
Revisit quarterly, and expect the bar to rise, in both directions. Materialized Lake Views (GA, Mar 2026) brought declarative data-quality constraints to Domain 4, and table health diagnostics (GA, Jun 2026) made maintenance something you measure before you run. Fabric Graph (GA, Jun 2026) is out of preview, while the Ontology item in Fabric IQ (preview, Nov 2025) is not, so ontology work in Domain 6 remains preparation rather than proof. And as capabilities become defaults, the level that once required them has to move down, or the rubric quietly starts rewarding a billing decision instead of a practice.
The maturity model is not about perfection. It's about knowing where you are, deciding where to invest, and measuring whether you're getting there.
A living catalog of 89 Microsoft Fabric capabilities across 11 catalog tabs: what each is, when to use it, when to skip it, and its GA or preview month.
Delta Lake and Apache Iceberg now match on core capabilities, so the choice comes down to three questions: which engine writes the table, which catalog governs it, and who must read it without a copy. A decision guide with the Microsoft Fabric interop paths.
Copilot and Fabric Data Agents answer from your semantic model's metadata, so preparing the model is the real AI work. A persona-mapped, flowchart-driven guide with brownfield and greenfield checklists.