Version-control & CI/CD your Power BI reports (Series)

No more PBIX files flying around! Control your Power BI reports using modern software development practices... I'll show you how to use two new features in the Premium pricing tier: Fabric Git-integration for versioning and Power BI Deployment pipelines for faster delivery of content updates

Version-control & CI/CD your Power BI reports (Series)

Setting the stage

No more PBIX files flying around! Control your Power BI reports using modern software development practices... I'll show you how to use two new features in the Premium pricing tier: Fabric Git-integration for versioning and Power BI Deployment pipelines for faster delivery of content updates and reduced manual work and errors; I'll also include an alternative approach for the Pro pricing-tier users with DevOps pipelines

  • Method #1. Using Fabric's Git Integration & Deployment pipelines (For Premium capacity users)
  • Method #2. Using DevOps Git Repos and Pipelines (For Power BI Pro users)

Method #1. Using Fabric's Git Integration & Deployment pipelines (For Premium capacity users)

Do you have Power BI premium capacity? Are your willing to develop Power BI report using feature that are still in preview? Are you ready to let go your PBIX (.pbix) files and use Power BI Desktop projects (.pbip) instead?

If the answer is yes to all of the questions above, method #1 for you! I'll show you you how to create an existing Power BI report (.pbix) and to version-control it via Fabric Git-integration (feature in preview), we then use another cutting-edge Fabric's Deployment pipelines to orchestrate the "deployment pipelines process"

The deployment process lets you clone content from one stage in the deployment pipeline to another, typically from development to test, and from test to production. (Ref. Understand deployment pipelines process)

Method #2. Using DevOps Git Repos and Pipelines (For Power BI Pro users)

You DO NOT have Premium capacity-enabled workspaces, nonetheless, would you like to have your existing reports version-controlled, right? Do you have Power BI Professional? You have access to Git-Repos and Pipelines services in Azure DevOps?

If the answer is yes, then, this alternative method #2 is the one for you! I'll show you how to orchestrated thru Azure DevOps pipelines a fully functional CI/CD cycle for your Power BI reports.

Bonus. Automate Fabric Deployment Pipelines with DevOps

On this article, I'll explain how to use Microsoft's DevOps extension Power BI automation tools to automate the execution of your Fabric Deployment Pipelines in order to deploy all/selected items in a Power BI pipeline to the next stage.


Call for action

Share your thoughts and what type of situation you're facing? Are you still using using publishing your Power BI reports on SharePoint, what type of issues you have face? Is there any other Method to consider? I would like to know from you, I activated the Member's discussion, looking forward to read your posts 😁