Decoupling Legacy Semantic Models Step-by-step guide

How to Decouple Default Semantic Models in Microsoft Fabric (Step-by-Step Guide)

Microsoft just released another important update around the retirement of Default Semantic Models, and this one moves us from “awareness” to action. If your Fabric environment has been quietly accumulating these auto-generated models, now’s the time to clean things up and take explicit ownership.

This guide walks you through exactly what Microsoft recommends and adds the practical steps I use with clients who need a clean, intentional semantic layer.

Why This Matters

  • Since September 5, 2025, Fabric no longer auto-creates Default Semantic Models when you stand up a warehouse, lakehouse, or mirrored database.

  • By November 30, 2025, any remaining Default Semantic Models will be permanently decoupled and become standalone models you manage manually going forward.

In short: the silent safety net is being removed, and your models now need deliberate governance, naming, ownership, and design.

This is a good thing—but only if you get ahead of it.

Step 1 — Inventory All Default Semantic Models

Before you change anything, get visibility. We want a complete list of:

  • The model name

  • The workspace

  • The source (warehouse, lakehouse, mirror)

  • Whether reports are actively using it

  • Last refresh / last dataset query

How to do it:

  • If you're an admin, pull a list via Fabric or Power BI admin APIs and filter those tagged as defaults.

  • If you’re a workspace lead, manually scan semantic models—default models usually inherit the warehouse or lakehouse name.

Deliverable:
A simple spreadsheet with columns for Workspace, Model, Source, Last Refresh, Last Used, and Active Reports.

Screenshot Suggestion:
Fabric workspace → Data hub → Semantic models list, filtered to show old defaults.

Step 2 — Classify Them: Keep, Consolidate, or Retire

Every default model falls into one of three buckets:

1. KEEP (actively used)

These power real reports and are good candidates to rebuild into proper enterprise models.

2. CONSOLIDATE (duplicates or overlapping)

Different teams often end up with variations of the same model. This is a chance to merge them into a single, well-structured semantic model.

3. RETIRE (unused or accidental artifacts)

If no reports use it, or no one can name a business owner, it’s safe to sunset.

Tip:
If it hasn’t refreshed or been queried in 90+ days, it’s almost always a retire candidate.

Step 3 — Plan Your Decoupling Window

Microsoft’s decoupling process is safe, but you still want intentional timing.

Once decoupled, these models:

  • Will no longer sync with their parent item

  • Will behave as regular semantic models

  • Will continue powering existing reports

Pick a change window and notify your business users. Treat this like a minor migration: communicate, test, and confirm nothing unexpected pops up.

Screenshot Suggestion:
Microsoft’s banner in the Workspace item that shows the deprecation notice.

Step 4 — Rebuild and Modernize the Models You’re Keeping

This is where the real value is. The default models weren’t designed—Fabric simply generated them. Rebuilding gives your org a semantic layer you can trust.

A structured approach:

  1. Export the model definition
    Bring it into PBIP or TMDL so it can be version-controlled and properly engineered.

  2. Refactor into a star schema
    Default models often include wide tables, unnecessary fields, and unclear relationships. Clean this up:

    • Identify facts and dimensions

    • Rename tables and fields

    • Remove clutter

  3. Strengthen the analytics layer
    Add standardized DAX measures, RLS, formatting, display folders, and descriptions.

  4. Choose the correct storage mode

    • Direct Lake for large, fast-moving Fabric data

    • Import or DirectQuery when needed for external sources

Screenshot Suggestion:
PBIP folder structure or a clean star-schema diagram.

Step 5 — Reconnect Reports to the Updated Models

Once your new semantic models are published:

  • Rename them clearly (e.g., Sales – Enterprise Semantic Model).

  • Repoint existing reports to the updated model.

  • Run regression tests to validate critical KPIs.

  • Have your business owners sign off before cutting over.

This is usually the smoothest part—Power BI handles the transition well as long as field names and structures remain consistent.

Step 6 — Remove Any Retired Models

For models you’re not keeping:

  • Double-check report dependencies

  • Document the removal

  • Delete the unused model

You’ll end up with a much cleaner workspace and less cognitive load for your analysts.

Step 7 — Put Governance in Place

If you want to avoid recreating the chaos in six months, put these basics in place:

  • Naming conventions for your semantic models

  • Defined owners (each model has a responsible person/area)

  • A review cycle for changes, schema adjustments, and new measures

  • Purview or similar tooling for lineage and metadata

  • Training for analysts so we’re building high-quality models consistently

This is where Fabric really shines: clean semantic models make your entire analytics estate more trustworthy—and unlock better downstream AI capabilities.

Final Thoughts

This decoupling update is more than a housekeeping task—it’s a chance to reset and rebuild your semantic layer with intention. The organizations that take this seriously will enjoy:

  • Cleaner workspaces

  • More reliable metrics

  • Less duplication

  • Faster development

  • Better AI-readiness

Next
Next

Office Online Server (OOS) is being deprecated