Power BI Mastery: End-to-End Analytics for Pro Developers

Hands-on deep dive into Power BI developer mode and the powerful capabilities unlocked by Power BI Project files (PBIP). In this session, you’ll explore TMDL and PBIR file formats, learning how they open the door to structured, source-controlled development workflows.

By the end of this workshop, you will:

• Gain a solid understanding of Power BI Project file formats (PBIP, TMDL, PBIR) and how they support modern, scalable development workflows.
• Learn how to effectively leverage AI to accelerate and enhance Power BI development, with hands-on, practical examples.
• Understand the value of applying DevOps and CI/CD practices to Power BI projects and walk away with actionable solutions—both out-of-the-box and community-driven.

🏁 Get started

• Ensure you met all the Requirements before starting the labs.

• Download this repository to your machine.

  

  Unzip the folder to a location of your choice. You will use the resource files in this folder throughout the labs.

• Open the lab documents in your browser for a better reading experience.

🧪 Labs

Lab 1 — Power BI Project (PBIP) Fundamentals

Hands-on experience with the Power BI Project (PBIP) format. Covers how PBIP files are organized on disk, setting up Git source control, publishing to a Fabric workspace, and editing semantic models and reports directly as code using TMDL and PBIR.

Lab 2 — Power BI & CI/CD

Build a production-grade CI/CD pipeline for a Power BI project on GitHub. Starting from a pre-configured repository template, you will configure automated deployments using GitHub Actions, enforce quality gates with the Best Practice Analyzer, and practice the Pull Request workflow.

Lab 3 — Power BI Development with AI

Learn how AI can supercharge your Power BI development - from batch-editing TMDL scripts with GitHub Copilot, to using AI agents to understand and update PBIR report files, to enforcing team best practices on a semantic model through an MCP server.

✅ Requirements

• Licenses

  • Access to a Fabric / Power BI tenant
    • You can use your existing organizational tenant but you must have admin permissions to create and authorize a service principal.
    • You can also create your own tenant using the Microsoft 365 Developer Program
    • Power BI Pro license
  • GitHub account
  • GitHub Copilot Free, Pro or Business
    • A Copilot license can be provided for use during the workshop. See sign-up-copilot-license for instructions.

• Software

  • Power BI Desktop - latest release
  • Visual Studio Code - latest release
  • Git for Windows
  • Python 3.13