Skip to content
PodSubs
ShowsPeopleGuestsJobsNewsEvents
More
BlogPodCred
Menu
ShowsPeopleGuestsJobsNewsEventsBlogPodCredNetworksSign in
Join nowSign in
  • Shows
  • People
  • Jobs
  • News
  • More
    • Guests
    • Events
    • Blog
    • PodCred
    • Networks
    Join nowSign in

Microsoft Cloud IT Pro Podcast

Microsoft Cloud IT Pro Podcast artwork

Episode 435: Power BI Meets Git and MCP

Aug 27, 202636 minAudio

Welcome to Episode 435 of the Microsoft Cloud IT Pro Podcast. In this episode, Ben and Scott take a lap around what’s new in Power BI, starting with the two MCP servers now in preview, one local and one remote, that can clean up your data model, write DAX for you, and turn a messy pile of tables into an actual usable semantic model. Ben shares how it helped him tame a 44 table QuickBooks Online mess, and why he had way better luck with it than with Copilot in Power BI. From there they get into PBIP, the newer Power BI project file format that breaks a report into files you can actually put in Git and collaborate on like real developers, branches, rollbacks, and all. It has been in preview since 2023 and still lacks solid guidance from Microsoft on wiring up CI/CD, but Ben and Scott dig into why it is worth adopting anyway, even if you are working solo. Show Notes Overview of the Power BI MCP servers (Preview) Power BI Desktop projects Git integration Power BI Modeling MCP Server Episode 90 - Power BI and Data Democratization with Alexander Arvidsson Episode 287 - Power BI Field Parameters and Microsoft Entra Optimize your semantic model for Copilot in Power BI Power BI Desktop projects (PREVIEW) Power BI Desktop projects Git integration Power BI projects, Git, and Team Collaboration About the sponsors Nasuni is a leading unstructured data platform for enterprises where file data is mission-critical for both people and AI. Nasuni powers the operational file layer where work happens - helping organizations manage, protect, and activate data so teams can work smarter, reduce costs, and operate securely without limits. Intelligink - Would you like to become the irreplaceable Microsoft 365 resource for your organization? Let us know!

Audio and video play straight from the show's own hosting. PodSubs stores and serves no media.

Transcript

From the show. Tap a time to play from there.

- Welcome to episode 435 - of the Microsoft Cloud IT Pro podcast recorded - live on 08/24/2026. - This is a show about about Microsoft three - sixty five and Azure from the perspective of - IT pros and end users, where we discuss - a topic or recent news and how it - relates to you. Today, Ben and Scott take - a lap around what's new in Power BI, - starting with the two MCP servers now in - preview, one local and one remote, that can - help you clean up your data model, write

- decks for you, and turn a messy pile - of tables into an actual usable semantic model. - From there, we dive into how you can - start using Power BI - with GitHub, - DevOps, or other Git repositories - to help you manage updates, changes, and even - Another - sweltering - 90 degree day in Florida. Before the sun - even comes up, this is just not - I don't know why people decided Florida was

- a good place to live. - Who knows? First place they landed and they - thought there was a fountain of youth here. - Yeah. It turns out it was not a - fountain of youth. It was a fountain of, - like, mosquito diseases, but - same difference. Anyways, we're not here to talk - about heat, humidity, - weather, - but all of that ties into data, which - we are gonna talk about. Well, how was - that? Yeah. You're getting so much better at - these. I'm trying, Scott. - Oh, and a trip down memory lane. Like, - this is a product that's been out for

- a while, and I don't know that we've - talked about this recently. We haven't. We've talked - about well, we're gonna talk about Power BI - today. So we're gonna talk about some new - things that have come in Power BI. I - think you were introducing me to some things, - and I was introducing you to some things. - And it was just very interesting how much - it has - changed - over time. - And I think if you've been stuck in - your ways of using Power BI - in, like, one modality, like, there's a whole - bunch of new things that are out there - and available to you from

- team collaboration - to MCP - servers, - like, - plural, that that can - help you out - and accelerate - your - pretty visualizations - in Power BI. Well, really, your, like, data - analysis, right, and and bringing things to bear. - Yeah. I would say just everything. - Like, for me, I don't spend a ton - of time in Power BI. Every once in - a while, it comes up or I'm working - on something or I want some reports, and - this kinda came up because I started playing - with it for a client that kinda wanted - a POC, and there are some things that - have definitely gotten easier. And then some things

- that you were informing me about too that - I missed. So where should we start with - Power BI today? Why don't we start with - the MCP - servers - and kinda do a little trip around the - block there? Because there's some other stuff that - we wanna talk about later when it comes - to, like, collaboration and things like that. But - I think we talk about that later because - the MCP server, at least one of them, - can be super helpful for interacting - with that new mode for Power BI development. - So let's start with

- the servers. Big overview, high level overview. There's - two MCP servers for Power BI. There's a - local and a remote. So you've got - different modes to think about when you were - interacting - with Power BI, the service, - versus - developing - Power BI through the Power BI app, and - maybe you're working with, like, PBX - files. You need help creating measures. - Maybe DAX isn't, like, your strong suit, but

- you've run into it kinda thing if you're - just getting started with Power BI. So there's - a bunch of kinda niceties across both of - those servers. So maybe we'll start with the - local one, and then we can kinda work - our way towards the the service one. How's - that sound? Sounds good to me. And - the local one is the one that I - I think it was the local one that - I spent the most time playing with. Because - it was, to your point, - I had - a client - that wanted to start building some reports on

- and it was actually QuickBooks data, QuickBooks online. - And Microsoft used to have this nice QuickBooks - Online data connector built right into Power BI, - and - they got rid of it. So I had - to go find other options and ended up - finding - a third party that I was able to - connect to the Power BI or the QuickBooks - online APIs, - dump content into - Data Lake, but then it was a lot - of data. Like and I will say QuickBooks

- online from looking at the data is not - the most intuitive - in terms of the databases and how they - structure some of the data. And I very - quickly got overwhelmed. Again, I don't do Power - BI a ton. I don't do QuickBooks - Online data a ton. And I got to - this point where I'm like, I have, like, - 50 tables. - And - just a glimpse into it, like, this was - looking at projects in QuickBooks online. And projects - in QuickBooks online end up in your customer - table with, like, a flag that it's a

- project and not actually a customer or a - project for a customer. - Like, super weird. And I was like, I - needed help. I was like, I don't know - how to sort through all this data. There - is a ton of data here. How can - I start digging through it? And I was - like, oh, I wonder if Power BI has - an MCP server. And lo and behold, here - is this local MCP server I could go - hook up. Yeah. The local one is super - super nifty. So for for those that haven't - played with it, you can go ahead and - wire this up to,

- I I mean, a couple different things. So - it really just requires any harness that can - allow you to interact with a local MCP, - so - Claude on the desktop. - If you're I believe you have I believe - you still have to be licensed for for - those to come through. But Claude Code, GitHub - Copilot, - anti gravity, - codex, - things like that. - So you can just go out. There's instructions - on GitHub to wire it up. It was - a little bit of a rough start when - this first came out, but way easier to - kinda configure and wire up to everything that's

- out there now. But - what the local MCP server does is - kind of cool. So if you're - sitting there and, say, you're working in - a PBYX file, so you've actually got Power - BI open, - and - you're sitting and you're working with an active - file, you can just go into - your - your LLM - interaction harness, whatever it happens to be, and - you can do things like, hey. Power BI - MCP server, connect to my local file.

- And it knows that Power BI is open, - and it's able to go and interact with - that PBIX file. So you can do things - like you can say, - maybe - look at my schema and tell me anything - that I should fix with my relationships. - Like, Power BI can get a little weird - sometimes, right, when it comes to the whole - star schema thing and - one to one. And sometimes it just wants - to do many to many's, And you're, like, - sitting there fighting it. Like, what's wrong with - the model? What what's going on that I - just can't work with it? So it's super

- good for things like that. Like, it's it - basically - has - inherent knowledge of Power BI modeling best practices - because it's kinda grounded and built on top - of all that. The other one that I - really liked with it - is I I can figure out Power Query - all day. Like, I'm used to it from - Excel and then in into Power BI, things - like that. I'm not good at all at - decks. Anytime I have to go look up - and especially get into, like, authoring, like, DAX, - I my my brain just doesn't work that - way. Like, it doesn't work for me. But

- that Power BI MCP server, the local one, - it lets - you not only - validate DAX functions that are out there, but - it can help you - write DAX queries against your model. It can - do things like go write a bunch of - measures for you. So say say you've never - worked with measures - and they're confusing you for the DAX and - things that comes along, you can do something - like, hey. Go connect to my local file - and - suggest to me suggest what measures I should

- have in this model. Or maybe you know, - like, kinda popular measures that you should have. - Maybe it's built, like you said, on, like, - Intuit data, like sales data, - invoices, things like that. So you'll know like, - you might want measures around, like, sales by - week, sales by month, sales by year kinda - thing. You just say, hey. Go create these - measures for me in this table or keep - the measures in the source tables, however you - wanna do it. And it will go and - spin those things up. Let's see what else. - It will troubleshoot calculations.

- That that is super helpful. - If you've ever been working with, like, trying - to, like, round things out, convert, - say, from, like, a double to a percentage, - things like that. Super helpful for all that. - I have a public safety message going off. - Yep. You're getting on alert. I agree. And - part of what I was too was, like, - I needed to create a semantic model, and - I had to narrow down these 44 tables, - And that's where I started using it. I - had - a - I had a report, and it was interesting. - Like, I had a report in Power BI

- that I wanted to replicate, and - I had all my data. So I was - like, no. I have all the data. I - have a report of what I want it - to look like, and I was able to - go feed it into - Claude, say, I have this report. Here's the - data. I need to essentially recreate this report. - Help walk me through it, and it was - able to go in and - help me generate - a semantic model and pull in the different - tables from - my - data lake and my lake house and all

- of that and really narrow it down. So - at the end of the day, I had - to net 44 tables. It built - the, like, six I needed with the relationships - between all of them, and then it was - able to go in and here's the - and I actually told that I wanted to - understand it more. So I was like, just - give me the instructions. How do I take - this data and build my PBIX file? So - I didn't have it build the whole table - for or the whole report for me. I - just had it walk me step by step - of what did you what's in each table, - what table goes in which chart, what charts

- should I use, how do I structure my - filters, - and actually almost had it teach me how - I wanted to take the - data and the models it had built and - build my PBIX report or the PBIX file, - build the report in Power BI so I - could understand it all. And then even some - notebooks that I needed running behind the scenes - to do some things from - data lake to lake houses and all of - that. So that's where I really found a - lot of benefit from that MCP server is,

- hey, Scott. I love your puppy in the - background. Yeah. If everybody's here in squeakers, that - that that's it. He's No. Really going through - and helping me - go from all of that extra data that - I didn't necessarily need to just narrow it - down to the data I need and how - I wanna build the report and what notebooks - I need and all of that. Yeah. I - think it's a good way to go about - those things. - So you can use - I think there's two ways that you can - generally - use a AI and then certainly, like, these - MCP servers, things like that. So you can

- either have them do the work for you, - or you can learn how to do the - work yourself and have this be kind of - an an aid or an accelerator for you. - And once you've made a decision, go in - a certain direction. - Sir, - so I think it is super helpful for - that iterative process - of coming through. And like I said, the - the MCP server is grounded in - things like the public docs. It understands best - practices. - It it knows what to do or ish

- what to do. You might have to teach - it a little bit about your model. I've - been kind of impressed at what it's been - able to infer just by throwing some raw - tables and things at it. And Power BI - is generally pretty good about that anyway. If - I've got - sale date in this table and the field - date of sale in this table, sometimes it - can figure out that, hey. These two things - are in fact dates for the same tail. - May may - for the same sail. Maybe it was more - like a fact and a dimension, - things like that. So it can do definitely - do it and - and and get you there. So

- so that's all good. So so you've got - a local MCP server. Author your files locally. - Work with them locally. - You get to be kinda human in the - loop and and go back and forth with - them. And then there's also - a remote MCP server. So - you can use that for - working - with your - semantic models that are already loaded up into - the Power BI service, things like that. So - if you're working, say, with, like I said,

- like, a semantic model, it's already up there, - maybe you've got access to it, You wanna - go and maybe - create a new Power BI report dashboard, something - like that based on an existing semantic model. - It can go up there and do very - similar things. It can help you generate, execute - DAX queries, - natural language conversations, - all all that kind of stuff. The other - one where I think the remote MCP server - could help is - one of the things I've found - AI to be generally good at, I would

- say doesn't tend to hallucinate nearly as much, - is just analyzing data. Looking over data and - saying, here's all my data. Like, help me - sort through it, sift through it, find certain - trends in it, that type of stuff. And - And I think that's where this remote MCP - server can could be nice too because like - you said, it can go connect to those - semantic models. So even if you're just trying - to understand your data a little bit more, - just using it to go query that data, - ask questions about your data, I found, not - to knock on Microsoft, but it's totally a

- knock on Microsoft, is the Copilot stuff in - Power BI, I did try that first, and - it was trash. I could not get it - to work and do what I wanted to. - And when I switched to these MCP servers - for query tools and hooked it up to - Claude, I had a lot more success with - it. So if you've used - Copilot and Power BI and you're frustrated, I - would say go give this a try because - I definitely had a lot letter better luck - with this. And, again, the remote MCP server,

- great for going in and looking through data. - I do wanna say too, Scott, both of - these are still in preview, so we need - to put our normal preview disclaimer on it. - These are both preview. - There's a comparison too between the road remote - MCP and local MCP that we'll link to - in the show notes. Right? Because there are - a few differences there in terms of, like, - what you can use for authentication. - It talks about the different tools that are - available, a few things there. If you are - trying to figure out, well, do I need - the local? Do I need the remote? Or - if one thing doesn't work in one of - them, what does the other one do, etcetera.

- There are some additional steps along the way - as well. So - I I didn't run into some of this - until I read the documentation because you you - don't always, like, click all the buttons in - the ribbon and things like that in Power - BI. So there's this kinda - front matter or front loaded step preparation step - to go and prepare your data for AI. - So if you're working both with the local - MCP server or the remote one, Power BI - local at least has a button go and - prepare your data for AI,

- and you can go and have it generate, - like, a AI ready schemas. So you have - to have Power BI q and a enabled - to be able to go and do this, - but you can just run through this set - of steps to kinda, - prepare your data for AI. It's what the - button says. It's what everything guides you into, - and it'll help you kinda optimize your schema - and optimize your semantic model for Copilot - or more broadly for LLMs - to be able to come in and understand

- all of this stuff. Yeah. - Yeah. So I don't know if you've run - through that step yet. I don't think I - did run through that step. I'm gonna have - to go back and look at that. It - will do things like remember I was talking - about, like, help you with your schema, maybe - get it back to, like, a a real, - like, star schema kind of thing. So it - can help you simplify your schema. - It can remove redundant fields, redundant measures, - think things like that. And then part of - it is you're kinda, like, grounding it and - asking it along the or it's asking you - along the way, like, hey. I did this - summarization. Does this look right to you? And

- you could say yes or no and and - go back and pivot. So it's another way - also to kinda not only clean up your - schema, but verify things like measure logic - and DAX, - and all of that is ready. And then - as part of that, you're gonna go through - and you're gonna mark things as - verified answers so that if somebody else is - using your model, they can also come in. - And you'll know that, like, consumers of your - model who are maybe using, like, Power BI, - q and a, or just Copilot, things like - that through through Versus Code, maybe they're using

- the MCP server and hooking up, that they're - getting - the right - the right answer all along the way. I'm - glad to see these MCPs too. I think - I've talked about it before. I I - more and more as people create MCPs, - I think that's - you get so much flexibility - out of MCPs in terms of what you - wanna do with data. I would much rather - see a whole bunch of people build a - whole bunch of MCPs - than everybody build all their own AI stuff - and just let me get my data wherever - I want to. Let me choose my own

- harness, choose my own AI platform, and give - me an MCP rather than, like, making me - stay in your tool or - your own specialized AI thing. I also get - it from a marketing perspective. Everybody wants your - eyes and their product, so they want you - to stay in theirs for their AI. The - more and more I can find MCPs, - it makes me happy. We could have a - whole another talk on We could have a - whole another talk on that. MCPs - and death of SaaS and things like that. - Should we move on from MCPs to something - else you told me about that I had - kinda completely missed when it came to Power

- BI? Like I said, once you have these - MCPs - in place, now you've got kind of a - a a little bit of a collaboration - scenario going on, whether it's you as human - in the loop, just you and kind of - model and the Power BI service - going back and forth, things like that. But - there's also the world where maybe you collaborate - with with other users, - maybe other agents, things that are out there. - Right? You said talk kinda talking through, like, - hey. You enjoy being able to work with - kind of, like, model and harness of your

- choice kind of thing. So so that's definitely - another consideration is now that you've got - these things out there, like, how can you - use them - with your existing harnesses, - existing agents, things like that? - So I forget when they added this. I - turned it on as soon as they did, - but there's an ability now in - Power BI - to - work on - collaborative files. - So if everybody's familiar with a p b

- PBIX - file, the kinda just raw file that encapsulates - your Power BI report locally that you work - with before you go and publish it to - the service, or maybe you just hang with - it locally and you never publish it to - the service kinda thing, There there's this new - file format for Power BI, - which is - a, - it it basically - allows - it'll it allows you to collaborate on these - things, and it breaks down a what is - a single PVAX file

- into - multiple files - that all end up in this - PBIP - file. I I do wonder what, like, like, - what they were thinking with the the the - acronyms on the end there. But, basically, what - a p b I b PBIP - fi IP file is - is it makes your, - it it makes - the Power BI - file - files, - basically,

- human readable. So that now you can do - things like you can store this, say, in, - like, GitHub and collaborate back and forth with - people. So, like, rather than me writing a - PBX, and then I gotta shut down Power - BI and then maybe share you a link - to it, and then you go work in - it. And then the next time I open - Power BI, it's probably broken, - or we both open it at the same - time and we really screw each other up - kinda thing, now you can actually get into - a collaborative - workflow - across these things. There's no, like, there's no - more having to email these things around, storm

- in a SharePoint site, - any anything like that. And because they're just - raw files, I said, you can storming in - a Git repository. - So now you get things like safe safe - rollback. You get actual, like, versioning versioning, - across things that are out there. But the - really kinda maybe, like, next level thing you - can do now is because you have these - MCP servers also understand that new file format. - So now you can have, like, agents that - sit alongside you. - So you could be, like, authoring one of - these things, and you could have an agent

- say that, like, runs daily - and does, like, sanity checks on your DAX - queries or things like that for you. Yeah. - If you're managing file storage today, you've probably - felt the pressure. Refresh cycles are harder to - plan, costs and complexity are increasing, especially as - file workloads scale across regions. - That's why Microsoft customers trust Nasuni. As an - Azure certified software, - Nasuni provides a global file system designed for - enterprise scale environments, - keeping file data secure, governed, and accessible across

- Azure environments without added infrastructure complexity. - It's the foundation to keep your unstructured data - stable even as your infrastructure - evolves. To see how much you could save - while keeping your initiatives on track, visit - nasuni.com/tco. - That's nasuni.com/tco. - This is cool, and I did look up - some dates, Scott. So this was - this has been a long time coming. It

- was announced in May - 2023. - It hit public preview in June 2023, and - it has been in public preview for the - last three years. And it's still technically labeled - preview, - although - we do have for Microsoft that general availability - is planned. So while it's still preview, this - one is probably relatively - safe to start using. - Every once in a while, I had one - of these recently, Scott, a preview feature that - got deprecated and never made it to GA. - It does happen. It does.

- And three three three years is a long - time to be in public preview. But, yeah, - I think I probably saw this, like, two - years ago or so maybe Okay. And started - playing around with it then. It I don't - I mean, - granted, I'm probably using it a way, like, - a high level, but it seems to work. - Like, it does what it says. It does - what it's supposed to do. Yeah. Yeah. It's - kinda cool. I almost like, like, when you - were starting to tell me about this, because - I haven't used it partly because - being in the position I am with consulting - and stuff, I don't tend to have a - ton of collaboration around Power BI stuff. But

- it almost feels like when we made the - move from the doc files to the docx - files, where the doc files are kind of - all self encapsulated, - docx is I mean, really just a zip - file with a bunch of other files in - it so that you can do the coauthoring - and stuff in Word and all of that. - This feels very similar where it was like - PBIX - was that self contained PBIP, which is Power - BI project, Scott. That's where it comes from. - I also saw that. - It's the way you were describing it, it's - very similar to that where now it's almost

- it's just a container with a bunch of - little files in it so that as you - are doing that coauthoring, - you're putting these in - source control. - It's able to go in and edit, like, - individual files and do diffs a little bit - better and all of that with that collaboration. - So that was kind of the analogy that - jumped out in my head. I'm like, okay. - Now it makes sense what those Power BI - PBIP - Power BI project files are. There's still some - proprietary stuff in there. So if you start - digging into the folders and things like that, - there there's definitely parts that are kinda just

- custom binary format and not meant for you - to use, but - you yeah. But you you can definitely - get in there and start playing with these. - Super easy to get going with. They do - recommend, - and I don't know, I haven't used it - with anything else other than, like, GitHub, but - just Git repos. But you could do this - with, like, a Git style repo in Azure - DevOps, - anything like that along the way. So now - if you think, like, back to, like, say, - like, the agents thing. - So you have one of these

- PBIP - projects. - You spin that up. When you do your - check-in let's say you are using Azure DevOps. - So you do your check-in. You can have - a pipeline run that goes and kinda validates - things for you. And you could potentially have - that pipeline - run and invoke something like an MCP to - go validate your schema, validate your DAX. Like, - you actually get a little bit more - a little bit more kinda, like, rigor and - governance, I guess, around release of these things - as they as they come out, which is - super nice to see. Right? It kinda makes

- it a little bit more, I think, a - little bit more, like, enterprise developer - versus, like, enterprise power user kinda thing. I - agree. Power BI, - it did seem to be very end user - focused - originally where it was go install it on - my desktop, create it there, I publish it - up, I share it out to people. This - is very much that collaborative development. Like, you - were talking about, I could even think if - you had, like, scheduled agents - that were running your scheduled tasks in your - LLM that had to go in and do - certain things in your Power BI report, publish

- it through a pipeline. - I feel like it this just greatly expands - the flexibility - and the flexibility - ability - aspects of what you can now start doing - with some of these Power BI reports, especially - because people always like them to be up - to date. And let's face it, when people - build reports on data like this, they kinda - want them to be accurate. So if you - can use some of these tools as well, - to your point, help ensure the accuracy, help - ensure the make sure everything is - working properly, working the way it should,

- I think there's a lot of lot of - options here that you start getting. Or just - the fact that now you can work on - a report with your best friend, Scott. You - and I can go work on reports together. - Best friend, your best AI agent, all all - those things. Yeah. All the things. I will - say one of the I guess - and I I wonder for being in preview - for three years now, like, why this gap - hasn't been filled more by Microsoft. - So if you go and you read the - documentation for this, it kinda - stops - at initialize a Git repo. So it tells

- you how to enable this. It tells you - how to - create the new folder structure format thing - and get you spun up and kinda how - to do - an initial load into a Git repo. But - it leaves - all the follow on stuff, and I think - the power of it, the the versioning, - CICD - capabilities, things like that, just as an exercise - to the reader. So you will have to - go out and Google Bing, DuckDuckGo, - Kage, whatever your search engine of choice is.

- If you're looking for, like, specific guidance on - how to configure, say, like, a CICD - pipeline - or some GitHub actions and wire them up - around this, you're gonna have to go, like, - find that stuff and hope somebody blogged about - it or figure it out and blog about - it yourself because that guidance doesn't exist from - Microsoft. Yeah. I was looking through this, and - it is. Like, that ends up with, here - you go. Initialize your git repo. And then - I was looking at one of the other - ones, editing Power BI files externally, and it - talks about how you can open them in

- Visual Studio Code. And it says, here's the - button. Just go open it in Visual Studio - Code. It doesn't really give you, like okay. - So once it's open in Visual Studio Code, - what am I supposed - to do with it? I now get access - to the report and semantic model definition files, - but what do I do from there? We'll - say it also does call out to your - earlier point, Scott, under some of the limitations - is - not all of those project files that you - may see open up in Visual Studio Code - or within this file - support - editing. It's not saying the blocks editing. Like,

- there's some JSON files in there, a report, - a mobile state, - semantic model diagram layout - where it's JSON. You could edit it in - any text editor, - but you might break it here because that's - not supported in this. So there are other - areas of the documentation - too that I would go read before you - just start editing some of those text based - files in there. I think if you're actually - gonna do it, like, in a collaborative way - too, like, say, you and I were kinda - going back and forth on something, you do - need to decide upfront

- about - kinda how you're gonna approach - isolation for, like, your changes versus my changes, - things like that. And, again, this is an - area that, like, Microsoft doesn't have, like, discrete - guidance for you or prescriptive guidance, but I - think there's plenty out there in the community. - So you can do things like - you and I could be working - in the same same report, same dashboard, - but we could have isolated - workspaces, - effectively, like, a dev workspace for you, a

- dev workspace for me. Like, if we were - working in, say, like, a a a Git - repo, - we'd wanna do things, like, probably, like, a - feature branch per workspace. So, like, I'm gonna - go spin up like, I'm gonna go work - on the - new DAX measures for for blah blah blah. - You're gonna go work on the visualizations - for report page - a, b, c kinda thing. So you you - do end up into, I think, more, like, - the geeky, like, Git semantics - that are out there. And, again, that's where - I'm more, like, enterprise developer than enterprise power

- user - if you do go down this path. But - there's definitely, like, some nicety there, I think, - even if you're just, like, a solo person. - Right? You wanna go and have kind of - that, like, go forward, go back, replay logic - that you get with things like a with, - like, a Git repo. - Could be worth learning even for, like, the - solo Power BI developer out there. Yeah. Because - even though this is collaborative, I'm assuming - because it is Git, you're still doing commits - and branches and all of that. And you

- could still - very much end up with a conflict if - you and I both decide to go edit - the same thing and change the same thing - in the same file at the same time - where then you have to decide which change - is better, my change or Scott's change? Yours - is always gonna be better. - It's definitely something worth looking at if you're - in Power BI a lot. If you and - coworkers are working on Power BI reports and - you wanna take some - or use some of that functionality, - this is something I will probably do as - well just from a I lose Power BI

- the PBI. I keep saying Power BI. I - lose PBIX files, Scott, all the time. I'm - like, where did I create it? Which desktop - documents folder did I put it in? - I for whatever reason, because you have to - save them locally and then publish Milan, I'm - always losing them. I'm like, you know what? - If I just started doing this and had - a git repo with all my Power BI - files or a git repo per client where - I'm creating these PBIP files, - it would just greatly help even to your - point as a solo person with

- keeping track of my different Power BI reports - and where kind of that source - report source file is. Move them all into - PBIP and GitHub. - I never even tried to convert one. Like, - can you convert them? I think you can. - I think I saw the documentation in there. - I always just start in, - start in a modality and go from there. - PbIP enable PB. Save as a project. If - you're working on a new project or you - opened an existing - Power BI Desktop PBIX file, you can save

- your work as a Power BI project file. - So you just do, like, the file save - as, and then in the drop down for - the save as type, you can switch it - to PBIP. That's an interesting so so, like, - like, these tools are so all over the - place. Like, I don't think I ever use - the save as dialogue - in Power BI once I initially create a - a a project and I go and publish - it. Once you publish it, it just asks - you to save again. Like, do you wanna - save this before you publish it to the - service? Yeah. I wanna save it. So I - would never see the save as dialogue.

- Now you can go use the save as. - Because I did see I think somewhere in - this documentation, - it does say that PBIP is going to - I'm assuming once it hits GA, turn into - the default file type. I would imagine. Right? - Like, that that would be kinda like the - happy path for these things to go on - is - let it just be the default state. And - it really doesn't matter at the end of - the day. Like, it's gonna be a set - of files and folders locally, or it's gonna - be a monolithic thing. - Arguably better, just have it be the files - and folders locally, and then if you wanna

- push to Git and be done with it. - Exactly. Just like we did with I'm gonna - go back to my office analogy. Just like - we did where doc and XLS and PPT - and the other ones all switched. They just - added an x there. Not to confuse you - because in Power BI, it had an x - and then it went to a p. - Naming, even when it comes to file types, - can be hard. Such is life. Yep. Alright, - Scott. With that, we are coming up on - our We got some new MCP servers, new - stuff for folks to go play within Power - BI. And we have meetings coming up that

- we should probably go to keep people happy. - I do. I don't know if you do. - I have a meeting coming up. I do. - I'm gonna roll from this one just into - my next, and - and then let's go. We'll have to come - back sometime and revisit the whole LLM Wiki - thing because, like, I went down your path - and built, like, a whole dashboard for mine, - and I went up, like, a little I - went a little wild on the side. But - Do you have any tokens left? Yes. I - have tokens left. Yeah. We will because I - keep expanding. I keep trying to - like, I need to actually get work done

- instead of playing with what can I build - with AI and my LLM Wiki and all - this other stuff? I tend to get a - little distracted with that. So we will come - back to that. But for those of you - listening, if you do - play with these, have any other thoughts, or - anything about Power BI and MCP servers and - Power BI or PBIP. - Would love - to hear from you. LinkedIn - or Reddit? We've had some more conversations lately - on Reddit as well. So I would say

- those are probably the - two social media - platforms you and I are both the most - active on is either LinkedIn or Certainly for - the podcast. That's a great place to find - us. Yep. Join us over there. And it's - been really good to have the feedback over - on Reddit. So folks should keep that coming. - For sure. And if you are gonna be - at TechCon three sixty five in Seattle this - week, this will come out Thursday morning. I - will be there Thursday and Friday. So if - you're there and you wanna say hi, come - say hi to me. Scott won't be there. - Sad face. I will not be at TechCon.

- Yeah. - Outside my wheelhouse these days. Yeah. Not so - much Azure storage blob stuff there. But for - now, go enjoy your Monday, Scott. Get some - work done. Enjoy the puppy, and we will - talk to you again soon. Thanks, Ben. - If you enjoyed the podcast, go leave us - a five star rating in iTunes. It helps - to get the word out so more IT - pros can learn about Office three sixty five - and Azure. - If you have any questions you want us - to address on the show or feedback about - the show, feel free to reach out via

- our website, Twitter, or Facebook. - Thanks again for listening, and have a great - day.

Open the transcript file

Hosts and Guests

Nobody is credited on this episode yet.

Credit the people on this episode

Be the first to rate this episode

More episodes

All episodes
  1. Episode 441: Microsoft Ignite 2026: Autopilot, Workspaces, and Spot Plus

    Nov 19, 202648 minAudio

    Welcome to Episode 441 of the Microsoft Cloud IT Pro Podcast. In this episode, Ben and Scott take a first pass at Microsoft Ignite 2026, starting with a question a lot of IT pros are asking: is the pace of change...

    Credit the people on this episode

  2. Episode 440: The J Factor: Bringing Your Experience to Generative AI

    Nov 5, 202638 minAudio

    Welcome to Episode 440 of the Microsoft Cloud IT Pro Podcast. Recorded live at the North American Cloud and Collaboration Summit in Branson, Missouri, this MS Cloud on the Road conversation has Ben sitting down with Jay...

    Credit the people on this episode

  3. Episode 439: Azure SRE Agent vs. the Azure Copilot Troubleshooting Agent

    Oct 22, 202638 minAudio

    Welcome to Episode 439 of the Microsoft Cloud IT Pro Podcast. In this episode, Ben and Scott dig into two Azure agents with confusingly different names: the Azure Copilot Troubleshooting Agent and the Azure SRE Agent....

    Credit the people on this episode

  4. Episode 438: Taking your WorkOS and LLM Wiki to the Next Level

    Oct 8, 202647 minAudio

    Welcome to Episode 438 of the Microsoft Cloud IT Pro Podcast. Back in Episode 429, Ben and Scott introduced LLM wikis. In this episode, they come back a few months later to compare what those wikis turned into after...

    Credit the people on this episode

  5. Episode 437: Nasuni and AI-Ready Unstructured Data with Nick Burling

    Sep 24, 202640 minAudio

    Welcome to Episode 437 of the Microsoft Cloud IT Pro Podcast. In this episode, Nick Burling, Chief Product Officer at Nasuni, joins Ben and Scott to talk about getting unstructured file data ready for AI. Nick digs into...

    Credit the people on this episode