Microsoft Fabric Business Intelligence Data Engineering

26-Item Microsoft Fabric Migration Checklist

26-Item Microsoft Fabric Migration Checklist
Microsoft Fabric Data Engineering

The 26-Item Microsoft Fabric Migration Checklist: What Most Teams Get Wrong

⏱️8 min read
Microsoft Fabric · Migration Planning

A practical Microsoft Fabric migration checklist covering planning, governance, capacity, security, and migration readiness.

Most Microsoft Fabric migration failures aren't caused by the technology. They're caused by steps that were known, documented somewhere, and skipped anyway - usually because the project was already moving before anyone wrote them down. We built a 26-item Microsoft Fabric migration checklist after watching the same handful of gaps show up project after project, across assessment, architecture, governance, execution, and post-migration optimization. This post walks through five of those items in depth - the ones most consistently skipped, and what skipping them actually costs.

Why Migration Checklists Get Skipped, Not Failed

Nobody sets out to skip a checklist item. What actually happens is more mundane: a step gets deferred because "we'll circle back to it," the deferral becomes permanent once the project has momentum, and the gap only becomes visible three months post-go-live when a report breaks, a capacity throttles, or a security review flags a workspace nobody owns. The pattern holds across almost every Fabric implementation checklist gap we've seen - the mistake was rarely ignorance. It was sequencing.

5 Checklist Items Most Teams Get Wrong

1
Pre-Migration Assessment
Audit every existing data source before scoping anything else
What most teams get wrong: Scoping capacity and architecture before completing a full inventory of source systems, schema complexity, data volumes, and refresh frequency. Without this, F-SKU sizing and migration sequencing are both built on guesses. A proper audit surfaces the duplicate sources and undocumented columns Fabric will otherwise make painfully visible after go-live, not before.
2
Architecture & Design
Size your F-SKU against workload profile, not your current Power BI Premium tier
What most teams get wrong: Treating F-SKU selection as a direct swap for an existing Power BI Premium P-SKU. The two licensing models don't map cleanly, and F64 is a genuine tipping point - above it, report viewers no longer need individual Power BI Pro licences, which changes the total cost math significantly. Sizing before understanding this threshold routinely leads to either an undersized capacity that throttles at peak reporting cycles, or an oversized one paying for idle headroom.
3
Migration Execution
Migrate by use case, never as a single "big bang" cutover
What most teams get wrong: Attempting to move every pipeline, dataset, and permission at once because it feels more decisive. In practice this becomes unmanageable almost immediately. The teams that succeed pick one critical pipeline, one priority report, or one sensitive data flow first, prove the pattern works, then repeat it - prioritizing by business impact rather than technical convenience.
4
Governance & Security
Design your workspace and domain structure before workspaces start multiplying
What most teams get wrong: Letting workspace creation happen organically during migration instead of defining a tenant > capacity > workspace > item structure up front, grouped by business or geographic domain. Without that structure decided early, workspaces multiply, ownership becomes unclear, and by the time governance gets attention retroactively, untangling it is a much bigger project than designing it would have been.
5
Post-Migration & Optimization
Set capacity auto-pause and CU monitoring before go-live, not after the first surprise bill
What most teams get wrong: Treating capacity governance as a post-launch cleanup task. Enabling auto-pause on development capacities, setting per-workspace storage quotas, and monitoring consumption through the Capacity Metrics App are all configuration decisions that take minutes before go-live and hours to unwind after a capacity has already been saturated by unconstrained usage.
Every one of these items was known in advance on every project where it caused a problem. The gap was never information - it was sequencing something before the migration had momentum, instead of catching it after.

What's in the Full 26-Item Checklist

The five items above sit inside five broader categories that make up the complete checklist - 26 items in total, covering the full arc from first discovery conversation to steady-state operation:

🔒 21 More Items in the Full Checklist
Pre-Migration Assessment
  • Define migration goals and success metrics
  • Secure executive sponsorship and funding
  • Measure data volume and growth rates
  • Map success metrics to technical tasks
  • Identify existing tool sprawl to consolidate
Architecture & Design
  • Choose medallion vs. simplified layer design
  • Plan OneLake Shortcuts for external sources
  • Decide Delta vs. Iceberg table strategy
  • Design semantic model ownership
  • Map legacy ETL logic to Fabric equivalents
Governance, Execution & Optimization
  • Assign Business Owner, Data Steward, Tech Owner per domain
  • Set up Purview scanning and sensitivity labels
  • Build a reconciliation and pipeline-testing framework
  • Plan legacy system decommissioning
  • Establish CU consumption showback by team
  • ...and 6 more
Free Download
Get all 26 items - the complete Microsoft Fabric migration checklist
Every item above, plus the 21 we didn't cover here, organized into a print-ready checklist your team can run against before, during, and after your Microsoft Fabric migration.
Download the Full Checklist →

Get the Complete Checklist

The five items covered here are the ones we see skipped most often - but they're five out of twenty-six, and the gaps that don't make this list still cause real delays and real budget overruns. If you're scoping a migration now, or mid-way through one and want a gut-check against what you might have missed, the full checklist is free to download and built to be run item by item against your own project, not read once and filed away.