Merging Power BI into Azure Devops

on YouTube ↗41m

" summary

Shows how Azure DevOps stores PBIX and extracted model JSON so teams get extract model JSON for diffs instead of fighting binary files, uses Visual Studio for repo work, Table Editor to export the data model, and Git for version history. Builds release pipelines that run PowerShell + service principal to call Power BI REST API, change dataset parameters, deploy reports/datasets across Dev→Test→Prod and create automated pull requests. Notes that XMLA-based deployments and Deployment Pipelines require Premium, agents take ~5 minutes to spin up but deployments run quickly.

AI-written summary · about

" chapters (10)

1. 0:00Introduction to Power BI and Azure DevOps
2. 3:35Why use Azure DevOps with Power BI
3. 6:04Current Power BI collaboration methods
4. 12:08Setting up service principles for automation
5. 14:14Demo: Azure DevOps repository setup
6. 16:29Demo: Extracting Power BI data model to JSON
7. 23:59Version control for Power BI files
8. 25:45Demo: Power BI deployment process
9. 38:40Automating deployment pipelines
10. 39:43Advanced deployment pipelines with Power BI

" related talks

• 48mGit off my lawn: Mastering Power BI Deployments with Git IntegrationDavid Mitchell · SQLBits 2024
• 01h 10mContinuous Integration for the BI DeveloperWolfgang Strasser · Global Azure 2021
• 01h 12mAzure DevOps and the SSIS Development LifecycleAndy Leonard · All Things Open 2020
• 01h 03mA lap around Azure DevopsJakob Ehn · NDC London 2019
• 41mBattle tested project planning with Azure Devops boardsSANDER STAD, Kevin Chant · SQLBits 2020
• 27mBuilding powerful DevOps pipelines with Microsoft Azure DevOpsAdmir Tuzović · Bosnia Agile Day 2018
• 01h 31mAccelerate Business Delivery With AI and DevOpsMohamed Radwan · DSC MENA 2024
• 53mAzure DevOps and the SSIS Development LifecycleAndy Leonard · Global Summer 2020 Azure Data Fest 2020