Episode 435: Power BI Meets Git and MCP


Episode 435: Power BI Meets Git and MCP

Hello Reader,

The next episode of the Microsoft Cloud IT Pro podcast has been released!

Power BI development is starting to look a little more like software development—and AI is becoming part of the workflow.

In Episode 435 of the Microsoft Cloud IT Pro Podcast, Ben and Scott explore two Power BI MCP servers currently in preview and how they can help with tasks like writing DAX, cleaning up data models, and turning a collection of tables into a more usable semantic model.

Ben shares a real-world example of using MCP to tackle a 44-table QuickBooks Online model and why the experience worked better for him than using Copilot directly in Power BI.

Then the conversation turns to PBIP, the Power BI project format that opens the door to more traditional development practices.

In this episode, we cover:

  • Local and remote MCP servers for Power BI
  • AI-assisted DAX and semantic model development
  • A real-world 44-table QuickBooks Online use case
  • PBIP and Git-based Power BI development
  • Branching, collaboration, version history, and rollbacks
  • Why PBIP can be useful even when you’re working solo
  • Where Microsoft’s CI/CD guidance still needs to mature

If you work with Power BI and have been looking for better ways to manage development, version control, or AI-assisted data modeling, this episode offers plenty to experiment with.

Like what you hear and want to support the show? Check out our membership options.​


Show Notes

About the sponsors

​Nasuni helps enterprises manage, protect, and activate unstructured file data so teams can work smarter, securely, and at scale.

Would you like to become the irreplaceable Microsoft 365 resource for your organization? Let us know!​

View today's episode

​https://www.msclouditpropodcast.com/episode435/​

Check out our episode archive!

​Unsubscribe from new episode emails · Preferences​

11250 Old Saint Augustine Rd. Ste. 15-339, Jacksonville, FL 32257
​
Unsubscribe from all Intelligink and MS Cloud IT Pro Podcast Email​

Welcome to the Microsoft Cloud IT Podcast!

The weekly newsletter to accompany our podcast about Microsoft 365 and Azure. Scott and Ben are a couple of IT Pros that with a long history with Microsoft products. Recently Ben focuses primarily on Microsoft 365 but does a fair amount in Azure, and Scott spends most of his time in Azure, but with a history in SharePoint and Microsoft 365 still enjoys that side of things as well. We started this podcast over 5 years ago and continue to enjoy chatting weekly about various topics and technically in Microsoft 365 and Azure, specifically as it relates to IT Pros.

Read more from Welcome to the Microsoft Cloud IT Podcast!
Promotional artwork for Episode 440 of the Microsoft Cloud IT Pro Podcast, featuring the episode title and a discussion of how professional experience, creativity, and human judgment shape the use of generative AI in IT consulting and Microsoft 365 workfl

Episode 440: The J Factor: Bringing Your Experience to Generative AI Hello Reader, The next episode of the Microsoft Cloud IT Pro podcast has been released! Listen Online Jay used to spend two weeks turning a customer workshop into a deliverable. Now a transcript and a Copilot Cowork skill get him there in under 45 minutes. So where does twenty-five years of experience fit when the AI does the writing? In Episode 440, recorded live at the North American Cloud and Collaboration Summit in...

Microsoft Cloud IT Pro Podcast Episode 438 artwork for “Taking Your WorkOS and LLM Wiki to the Next Level,” featuring a laptop with digital learning, search, workflow, and knowledge management icons.

Episode 438: Taking your WorkOS and LLM Wiki to the Next Level Hello Reader, The next episode of the Microsoft Cloud IT Pro podcast has been released! Listen Online A few months ago, Ben and Scott started experimenting with LLM Wikis. But what happens when you stop treating an AI knowledge base as an experiment and start relying on it every day? In Episode 438: Taking Your WorkOS and LLM Wiki to the Next Level, they revisit those systems and compare what happened after months of real-world...

Podcast Episode 434 cover titled “Reading the Spec Sheet on Microsoft’s Agentic SOC,” featuring a digital security shield with a keyhole between bug and checklist icons against a blue cybersecurity network background.

Episode 434: Reading the Spec Sheet on Microsoft's Agentic SOC Hello Reader, The next episode of the Microsoft Cloud IT Pro podcast has been released! Listen Online Microsoft describes Project Perception as a “workforce of AI agents” for security operations. But once you get beyond that description, what does the technology actually require from your organization? In Episode 434 of the Microsoft Cloud IT Pro Podcast, Ben and Scott read through the details of Microsoft’s Agentic SOC to...