Forum Discussion
Anonymous
1 year agoNot applicable
Governance Model for Multi-Team Power BI Environment (Admin Oversight+Team Ownership)
Hi Community, We are in the process of migrating reports from Sisense to Power BI. Currently, we are on Premium capacity and will soon transition to Fabric capacity. Our setup: Our team functi...
- 1 year ago
I would suggest a hybrid approach:
- Create three workspaces: Dev, Test, and Prod.
- Set up an Azure DevOps repository with a Dev branch and restricted feature branches; enforce branch policies so writes require a Pull Request.
- Integrate the Dev branch with the Dev workspace; do not bind feature branches to shared Test—promote to Test via the deployment pipeline or a protected release branch.
- Create deployment pipelines and restrict deploy permissions so developers cannot promote to Prod.
- Grant developers Member/Contributor rights in Dev; keep Test and Prod controlled by admins with the highest privileges.
- Developers build in Dev; multiple developers can work in parallel since the Dev workspace is integrated with Git.
- For promotions, developers raise a PR from the feature branch into the Dev (or release) branch; the PR triggers best‑practice scans (e.g., semantic model BPA).
- The validation pipeline flags any violations for remediation.
- Admins review results and approve or reject the PR and subsequent promotion.
- After approval, changes sync to Test (via pipeline promotion or release-branch sync), and the admin team performs testing.
- Use the deployment pipeline to promote from Test to Prod with a manual approval gate.
Use Fabric workspace variables, deployment rules, and APIs to swap environment-specific settings and reduce manual steps.
tharunkumarRTK
1 year agoSuper User
I would suggest a hybrid approach:
- Create three workspaces: Dev, Test, and Prod.
- Set up an Azure DevOps repository with a Dev branch and restricted feature branches; enforce branch policies so writes require a Pull Request.
- Integrate the Dev branch with the Dev workspace; do not bind feature branches to shared Test—promote to Test via the deployment pipeline or a protected release branch.
- Create deployment pipelines and restrict deploy permissions so developers cannot promote to Prod.
- Grant developers Member/Contributor rights in Dev; keep Test and Prod controlled by admins with the highest privileges.
- Developers build in Dev; multiple developers can work in parallel since the Dev workspace is integrated with Git.
- For promotions, developers raise a PR from the feature branch into the Dev (or release) branch; the PR triggers best‑practice scans (e.g., semantic model BPA).
- The validation pipeline flags any violations for remediation.
- Admins review results and approve or reject the PR and subsequent promotion.
- After approval, changes sync to Test (via pipeline promotion or release-branch sync), and the admin team performs testing.
- Use the deployment pipeline to promote from Test to Prod with a manual approval gate.
Use Fabric workspace variables, deployment rules, and APIs to swap environment-specific settings and reduce manual steps.
Anonymous
11 months agoNot applicable
We will test and get back here for further assistance