This page contains a curated collection of Power BI DevOps community resources.
Articles
Power BI DevOps
- https://blog.octo.com/breaking-down-continuous-delivery-on-power-bi/
- https://data-marc.com/2019/11/12/versioning-and-ci-cd-for-power-bi-with-azure-devops/
- https://www.data-insights.de/devopswithpowerbi/
- https://thesqlpro.wordpress.com/2020/11/04/the-power-of-devops-and-deploying-power-bi-reports-to-different-environments-guest-post/
- https://community.powerbi.com/t5/Community-Blog/PowerBI-CICD-using-Azure-DevOps/ba-p/769244
- https://medium.com/swlh/automate-you-power-bi-reports-deployment-using-azure-devops-5ada8915d401
- Setting up Version Control for my Power BI Desktop Files (PBIX) | Gilbert Quevauvilliers Part 1 Part 2
- Power BI Version Control – Ready to use solution
- https://medium.com/capgemini-microsoft-team/power-bi-source-control-till-deployment-e4aaf8713922
- https://www.dataunlock.com.au/how-to-implement-source-control-and-ci-cd-for-power-bi/
- https://www.campana-schott.com/de/en/company/media-events/detail/versioning-approval-stages-and-automated-deployment-of-power-bi-reports-with-azure-devops
Article Series
- Bringing DataOps to Power BI | John Kerski Part 1 Part 2 Part 3 Part 4 Part 5 Part 6 Part 7 Part 8 Part 9 Part 10 Part 11 Part 12 Part 13 Part 14 Part 15 Part 16 Part 17 Part 18 Part 19 Part 20
- Tabular Editor Blog Series: “You’re Deploying it Wrong!” | Daniel Otykier Part 1 Part 2 Part 3 Part 4 Part 5
Deployment Pipelines
- https://docs.microsoft.com/power-bi/create-reports/deployment-pipelines-overview
- https://docs.microsoft.com/power-bi/create-reports/deployment-pipelines-automation
- https://docs.microsoft.com/power-bi/create-reports/deployment-pipelines-best-practices
- https://data-marc.com/2021/06/04/integrate-power-bi-deployment-pipelines-with-azure-devops/ (4 Jun 2021)
Azure DevOps
DevOps General
- https://devblogs.microsoft.com/devops/devops-dojo-culture-and-mindset/
- The Three Ways: The Principles Underpinning DevOps | Gene Kim
Git Source Control
Power BI Service Principals
- https://powerbi.microsoft.com/blog/use-power-bi-api-with-service-principal-preview/ (6 Feb 2019)
- https://docs.microsoft.com/power-bi/admin/service-premium-service-principal
Audio/Video
- Enterprise Power BI Deployment with Azure DevOps | Marc Lelijveld (28 Jun 2021)
- Power BI DevOps for Enterprise Projects | Bob Duffy (recorded 19 May 2021)
- PASS Summit 2020: Power BI CI/CD with Tabular Editor | Daniel Otykier
- Guy in a Cube: Deployment Pipelines give you more CONTROL (Power BI Premium)
- Havens Consulting: Implementing Proper Version Control in Power BI! | Steve Campbell
- Power BI Dev Camp Session 15 Learn ALM in Power BI with Deployment Pipelines
- Creating a Deployment Pipeline in the Power BI Service | Reid Havens
- Enterprise Power BI Deployment with Azure DevOps | Marc Lelijveld
- Guy in a Cube: Source Control with Power BI - Can it be done?
Books
- Effective DevOps. Jennifer Davis, Ryn Daniels (O’Reilly)
- Operations Anti-Patterns, DevOps Solutions. Jeffery D. Smith (Manning)
- The DevOps Handbook, 2nd edition. Gene Kim, Jez Humble, John Willis, Patrick Debois, Nicole Forsgren (IT Revolution)
Microsoft Announcements
Power BI Deployment Pipelines
- https://powerbi.microsoft.com/blog/deployment-pipelines-azure-devops-extension-multiple-pipelines-working-together-dataflows-ga/ (19 Jan 2022)
- https://powerbi.microsoft.com/blog/automate-deployments-with-deployment-pipelines-api-preview/ (25 May 2021)
- https://powerbi.microsoft.com/blog/announcing-new-deployment-pipelines-capabilities/ (29 Mar 2021)
- https://powerbi.microsoft.com/blog/enhance-deployment-pipelines-creation-with-premium-per-user-license/ (15 Dec 2020)
- https://powerbi.microsoft.com/blog/power-bi-september-2020-feature-summary/#deployment_pipelines_ga (22 Sep 2020)
Tools
Community Tools
- https://github.com/RuiRomano/pbidevops
- https://github.com/gbrueckl/PowerBI.CICD
- https://github.com/synchrotech/powerbi-source-control
- https://github.com/m-kovalsky/Tabular
- https://github.com/Hugoberry/pbix-diff-workflow
- https://github.com/TabularEditor/DevOps
- https://github.com/nathangiusti/Power-BI-VC-Utils
- https://powerbihelper.org/
- https://thebipower.fr/index.php/power-bi-sidetools/
- http://alm-toolkit.com/
Commercial Solutions
- Azure DevOps Pipelines
- GitHub Actions
- https://octopus.com/
- https://www.powerbisentinel.com/power-bi-devops/
Azure DevOps Extensions
- Power BI automation tools | Microsoft
- Power BI Actions | Maik van der Gaag
- Power BI Build Tools | Bob Guidinger (Last updated 2020)
- Set Power BI dataset parameters | Ali Mostafa (last updated 2018)
- Publish Power BI File | Maik van der Gaag (discontinued)
APIs
- https://docs.microsoft.com/rest/api/power-bi/pipelines
- https://www.nuget.org/packages/Microsoft.PowerBI.Api/
- https://www.nuget.org/profiles/NuGetAnalysisSrvs