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
Want to implement this in your workflow, too?
David Loos
David is co-founder of Plainsight and has been in data and analytics for well over fifteen years. He's held every role from developer to program manager, and has led data strategy and architecture for organizations like Delhaize, VDAB, Fluvius, and Barco. He completed Vlerick's Advanced Management Programme, which says as much about how he thinks about business as it does about data.