Episode 435: Power BI Meets Git and MCP
Summary
Ben and Scott explore new Power BI features, including local and remote MCP servers in preview that assist with data modeling, DAX writing, and schema optimization via AI harnesses. They also discuss the PBIP file format, which enables Git-based version control and collaborative development for Power BI projects. The episode highlights how these tools improve workflow efficiency, governance, and team collaboration for IT pros.
Topics discussed
Intro: New Power BI features, MCP servers, and collaboration
Overview of Local vs Remote MCP Servers for Power BI
Using Local MCP Server for Data Modeling and DAX
Remote MCP Server for Service Models and Data Analysis
Benefits of MCPs and Introduction to PBIP File Format
PBIP Structure: Human-Readable Files for Git Collaboration
PBIP Preview Status and CI/CD Pipeline Integration
Enterprise Development: Governance and External Editing
Collaboration Strategies: Branching and Conflict Resolution
Converting PBIX to PBIP and Future Default Formats
Outro: Social Media, TechCon 365, and Feedback
Listen ad-free on Castria