There are a lot of really cool free, community-developed tools and resources out there for Power BI and Fabric – so many that it’s easy to miss announcements about them. In this post I thought I’d highlight a few that came out recently and which you might want to check out.
Let’s start with the Fabric Toolbox, a collection of tools, samples, scripts and accelerators created and maintained by some of my colleagues here at Microsoft. The most widely-known tool in there is FUAM (Fabric Unified Admin Monitoring), a solution accelerator for monitoring an enterprise Power BI and Fabric implementations. It’s the successor to Rui Romano’s Power BI monitoring solution, which is now deprecated, but it’s a lot richer than that. It’s already been the subject of a Guy In A Cube video though so I hope you’ve already come across it. There are other things in the Fabric Toolbox that should be more widely known though. My fellow CAT Phil Seamark (why doesn’t he blog anymore???) has been busy: a month ago he announced a new Power BI load testing tool (video here) based on Fabric notebooks which is much easier to configure than the previous load testing tool created by the CAT team. He’s also published a sample MCP Server that, among other things, can analyse a semantic model to see whether it follows best practices. Another colleague, Justin Martin, has published tools for auditing semantic models and DAX performance tuning in the toolbox too. Finally, with the deprecation of Power BI Datamarts looming, if you choose to replace them with Direct Lake semantic models based on Fabric Warehouse (although I think 90% of the Datamarts I’ve seen can be replaced with simple Import models) then there’s a migration accelerator here.
Elsewhere, if you’re a hardcore Power BI developer you’ll already know how useful TMDL View in Power BI Desktop is. Rui Romano recently announced that there’s a new gallery of TMDL scripts where you can see what’s possible with TMDL and share your own scripts. For example, there’s a script here that creates a date dimension table from a Power Query query.
Two years ago I blogged about a tool called PBI Inspector that provides rules-based best practices testing for the Power BI visualisation layer, created by yet another Microsoft colleague, Nat van Gulck. Not only is there now a V2 of PBI Inspector, which will be renamed Fab Inspector, but two weeks ago Nat announced a VS Code extension that allows you to write, debug and run rules from VS Code.
Last of all Gerhard Brueckl recently announced V2 of Fabric Studio, an incredibly powerful VS Code extension that acts as a wrapper for the Power BI/Fabric REST APIs. It lets you browse your workspaces and their contents from VS Code and create/update/delete items among other things; Gilbert Quevauvilliers recently wrote a nice blog post showing how you can use it to download any Power BI report from the Service easily.
That’s enough for now. If there are other tools or resources that came out recently that I didn’t mention, please leave a comment!
The Fabric MCP server from Santhosh Ravindran is definitely also worth mentioning!
https://github.com/santhoshravindran7/Fabric-Analytics-MCP/tree/master
Recently I was looking for way or a tool to easily report on all Workspaces (really those with Capacity). Then provide who had access and what level to each workspace and/or a specific item in the workspace. Later for audit, but right now to get a better handles on who has what where type of things for informing others.
Have you seen anything like that?
Hi Alan. Not sure if I’ve seen a tool, but at Manchester Fabric UG and Jake Duddy (MVP) did a chat on using Graph techniques and had some interesting scripts which seem to fit your ask. The session was recorded but maybe a few days to be uploaded, but Jake talks about solution here and maybe you can reach out : https://www.linkedin.com/posts/jakeduddy_visualizing-power-bi-permission-inheritance-activity-7289230114205138944-BJ9p?utm_source=share&utm_medium=member_desktop&rcm=ACoAAAOl-aQBN9HbnCsVupEFphrrPPFKIwHRC6w
https://evaluationcontext.github.io/posts/graphframes/
https://evaluationcontext.github.io/posts/deneb-force-directed/
https://evaluationcontext.github.io/posts/KQLGraph/
Here’s a free tool that will auto backup every report, model, and dataflow and then extract all the metadata to easily view lineage down to the visual level, including links to the visuals/pages.
See used and unused objects, Broken visuals, measure lineage, refresh history, and more.
The final output is a Power BI report. It’s super useful to know what reports will be affected across all of Power BI for any model change – especially when multiple reports are connected to a single model!
https://github.com/chris1642/Power-BI-Backup-Impact-Analysis-Governance-Solution
How do we compare and automate latest changes of one model to other dependent model(where it has few additional data source).. ? But almost same… Version control of TDML and send those changes as alert etc ? Any tool?
And interviews at: https://fabricdownunder.com
Checkout FabricFlow : https://github.com/ladparth/fabricflow
A code first approach to MS Fabric Data Pipelines using prebuilt templates. It is a wrapper around MS Fabric REST APIs for Data Pipelines.