CI/CD workflow for Power BI reports fully automated! (Series)

In this video, we explore how to design and implement a fully automated Continuous Integration and Continuous Deployment (CI/CD) workflow for Power BI reports inside Microsoft Fabric, using Azure DevOps and service principals — all while staying 100% compliant with enterprise security and MFA requirements.

📘 Article series (deep dive): https://www.techtacofriday.com/ci-cd-...

💻 Source code: https://dev.azure.com/techtacofriday/...

🚀 What You’ll Learn:
How to automate your Power BI report deployments with Fabric and Azure DevOps.
Setting up service principals, Key Vault secrets, and Fabric capacities with PowerShell.
Building a secure infrastructure that separates Fabric and Azure resource layers.
Integrating Power BI and Fabric with Git for true source control and versioning.
Using Fabric Deployment Pipelines for seamless movement across Dev → UAT → Prod.
Managing approvals, pull requests, and validation through DevOps automation.

Timestamps:
00:00 – Introduction & MFA challenges
01:45 – Overview of Fabric + Azure DevOps integration
10:00 – Setting up Fabric capacity with PowerShell
18:00 – Configuring DevOps environments & service connections
22:00 – Automating Fabric workspace creation
29:00 – Publishing Power BI reports to Fabric
36:00 – Using Fabric Deployment Pipelines
43:00 – Managing changes and pull requests in Git
50:00 – Automated promotion & approvals in DevOps
55:00 – Final thoughts and next steps