Using PowerShell to create Calculation Groups in Power BI Desktop

Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop

Visualise your Power BI refresh – in real-time

Introduction I recently wrote an article showing how you can visualise a dataset refresh using Power BI. It was a pretty cool way to show some of the internal workings of what otherwise is a black box. The idea from my earlier article uses SSMS Profiler to run a trace against a database hosted in Continue reading Visualise your Power BI refresh – in real-time

Use Visual Studio Code to create Power BI External Tool

For this article, I want to share a way for you to create your own Power BI “Helper Tool” and register it as an external tool in Power BI. This article carries on from some of my recent articles on how you can use Visual Studio Code to help automate specific tasks by taking advantage Continue reading Use Visual Studio Code to create Power BI External Tool