Forum Discussion

Flo1's avatar
Flo1
Advocate I
8 months ago
Solved

How to organize a Version Control Strategy in Power BI using Azure DevOps

Hi folks,   I have a general question about organizing a suitable development strategy for version control in Power BI using Azure DevOps.   I have a PPU workspace called Workspace1 in Power BI S...
  • Mauro89's avatar
    8 months ago

    Hi  Flo1,

     

    here's a practical version control strategy for your Power BI workspace:

     

    Branch Strategy:

    Main branch: Production-ready reports only (what's in Workspace1) Feature branches: One per report or feature - feature/report-sales-dashboard, feature/report-inventory Development branch (optional): Staging area before merging to main

    Workflow for developing reports:

    1. Create a feature branch from main: git checkout -b feature/new-sales-report
    2. Develop your report locally in Power BI Desktop
    3. Save as .pbix and commit to your feature branch
    4. Push to Azure DevOps: git push origin feature/new-sales-report
    5. Create a Pull Request to merge into main
    6. After approval, merge to main and sync to Power BI Service

    To restore an older version of a single report:

    1. Find the version: In Azure DevOps, navigate to Repos → Commits → find the specific report's commit history
    2. Create a restore branch: git checkout -b restore/sales-report-v2 <commit-hash>
    3. Extract the specific .pbix file from that commit
    4. Upload manually to Power BI Service or commit to a new branch and merge

    Best practices:

    • Tag releases: Use Git tags for major versions: git tag v1.0-sales-report
    • Commit granularly: One report per commit when possible, with clear messages: "Update Sales Report - added Q4 data"
    • Separate .pbix files: Keep each report as a separate .pbix file in the repo for independent versioning
    • Use .gitignore: Exclude temp files but keep .pbix files tracked

    Feel free to check out also the MSFT docs for further options and hints: Git integration workspaces - Microsoft Fabric | Microsoft Learn

     

    Best regards!

    PS: If you find this post helpful consider leaving kudos or mark it as solution