How to Deploy and Configure 12 Microsoft Fabric Capacities in a matter of hours
THE CHALLENGE
Deploy 12 Fabric Capacities
Across 4 business Units
With a dev, tst & prd capacity
With a Bronze, Silver, Gold & Control workspace for every capacity
Including Access rights for Data platform & data engineers
🦸 The Accelerator: Fabric Foundation
Instead of manually provisioning everything, we turned to Fabric Foundation an accelerator developed by Plainsight.
Fabric Foundation provides:
Infrastructure-as-Code templates (infra)
Reference solutions for structured data zones (solution)
A comprehensive wiki for documentation and governance standards
It integrates natively with Azure, Microsoft Entra, and the Fabric control model to deliver a repeatable and governed setup for Microsoft Fabric.
🔧 How We Did It
Using Fabric Foundation, you are able to:
Automate resource group provisioning per BU and environment (e.g.,
rg-dataplat-bu1-dev)Deploy Fabric capacities (
afcbu) linked to their designated environmentsGenerate 4 core workspaces per capacity:
Bronze: Raw data
Silver: Cleaned & transformed
Gold: Business-ready
Control Center: Monitoring & admin
Assign role-based access via predefined Azure AD groups, ensuring least privilege by default
The result: A clean, scalable, and governed multi-BU Fabric implementation.
🧠 Lessons Learned
Structure pays off: Having a strict
dev/tst/prdseparation avoids messy overlaps between test and production pipelines.Governance is key: With access roles defined up front, we prevented shadow IT and inconsistent permissions.
Automation wins: Deploying this manually would have taken weeks. With Fabric Foundation, we cut that time drastically.
✅ Final Thoughts
Deploying & configuring Microsoft Fabric at scale doesn’t have to be chaos. With the right blueprint and tooling, it’s completely possible to go from zero to governed, scalable, multi-environment Fabric in a matter of months, weeks, days, hours.
If you’re planning a similar rollout, check out Fabric Foundation. It’s open, flexible, and battle-tested.
Interested in the full script or implementation advice 👉 david.loos@plainsight.pro
