Deployment patterns for Microsoft Fabric and Power BI

Five ways to get your work from where you build it to where the business reads it. Which one you can use is mostly decided already, by whether you have Fabric capacity and whether you need more than Power BI.

Patterns
Five, from one workspace to a mixed estate
Last reviewed
September 2026
Sources
Microsoft Learn, with the mixed estate pattern measured first-hand

What actually decides this

Not how big your team is, or how good. Two things: whether anyone has bought Fabric capacity, and whether you need anything beyond Power BI. Both are usually settled before you get a say in them.

The five patterns plotted against what they cost and how they promote. Left of the budget line, on no Fabric capacity: one workspace, promoted by nothing, and three Pro workspaces, promoted by a person. Right of it, on capacity: a mixed estate on engineering capacity, promoted by a script, and on capacity everywhere, deployment pipelines promoted by a pipeline button and git and build promoted by a build. Promotion is done byFabric capacitynothinga persona pipeline buttona scripta buildNo capacityEngineering onlyCapacity everywherethe budget lineOne workspaceThree ProworkspacesDeploymentpipelinesMixed estateGit and buildData NovaSave SVG

The moment that matters is when somebody other than you starts making decisions from your report. Before that, building everything in one workspace is fine. After that, the place people read from cannot be the place you are still working in.

So start from what you already have. Read the pattern next to yours too: each page ends with the signs that you have outgrown it, and says where to go next.

Git and pipelines do different jobs

Most teams arrive at this guide asking "git or deployment pipelines?". The question has no answer, because the two are not alternatives. Git stores your work and gives you history and review. It does not move anything into production. The moving is done by a deployment pipeline, or by a build running fabric-cicd(opens in a new tab).

Which is where the word gets slippery, because two different things are called a pipeline. A Fabric deployment pipeline is the Fabric feature that promotes items between workspace stages. An Azure DevOps pipeline runs a build, and the build is what deploys. This guide means the Fabric one unless it says Azure DevOps.

So plenty of teams run both: git on the development workspace for the history, a deployment pipeline to promote from there to test and production.

Choose a pattern

Four questions, in order. Stop at the first one that sends you somewhere.

AskIf the answer isRead this pattern
Does anyone other than you depend on these reports?No, still exploringOne workspace
Do you need lakehouses, notebooks, warehouses or data pipelines?No, Power BI only, and Pro licences onlyThree Pro workspaces
Can every environment sit on a Fabric capacity?No, capacity for engineering onlyMixed estate
Do you need history, rollback, code review or parallel developers?Not yetDeployment pipelines
Do you need history, rollback, code review or parallel developers?Yes, any of themGit and build
The four questions, and the pattern each answer sends you to.
Whichever pattern you land on, nothing in Fabric carries your data, your connections or your credentials into the target environment.

The five, side by side

One workspacePro, manualPipelinesGit and buildMixed estate
Fabric capacity neededNoneNoneEvery stageEvery stageEngineering only
Per-user licencesPro, onePro, everyonePro to build, free viewers on F64 and aboveSame as pipelinesPro to view reports
Non-Power BI Fabric itemsNoNoYesYesIn the capacity half
Promotion mechanismNonePublish from DesktopPipeline button or APIA build step from a repositoryA notebook over REST
History and rollbackNoNoNoYesYes, if the repository drives it
Parallel developersPainfulPainfulWorkableDesigned for itWorkable
Effort to stand upNoneHalf a dayA dayA week or moreA week or more
Effort to runNoneHigh, and error-proneLowLow once builtMedium
What characteristically goes wrongSomeone reads a half-built changeA publish goes to the wrong workspaceA bad deploy reaches production with no way backOne report changes and everything redeploysA deploy succeeds against the wrong environment
The five patterns against the nine things that separate them.

Patterns in detail

00

One workspace

You are the only one building, and the only one looking. Fine until somebody else starts making decisions from it.

Read the pattern

True in every pattern

Four things hold whichever of the five you land on, and they are the four that cost people the most: what carries your credentials, how you configure per environment, how you tell a deployment worked, and how you keep the environment visible in a name. The seventh page covers them, along with how to move between patterns once you have outgrown one, a checklist to run before you build, and every source behind this guide.

Read what is true in every pattern

Practical next step

Moving between patterns is much easier to plan than to improvise. Assign three existing workspaces into pipeline stages without first checking how the items pair up, and you get duplicates instead of a release process. If you are weighing two of these against real licences and a real audience, an assessment can test the decision before you build it.

Talk it through