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

Disable auto-format of JSON in SSMS

If you ever work with TMSL based scripts (basically big chunks of text in JSON format) in SQL Server Management Studio (SSMS), you may find that SSMS sometimes auto formats your JSON after you paste some script into the Text Editor. This can be mildly frustrating, but also potentially dangerous if elements are stripped without Continue reading Disable auto-format of JSON in SSMS

Automatically create measures in Power BI using VS Code

My last blog introduced the idea of using Microsoft Visual Studio Code to work with Power BI Models. For this article, I build on that idea by showing how you can use a TOM based script to automatically generate measures in your model Power BI (or Azure Analysis Services) model. For simplicity, the example in Continue reading Automatically create measures in Power BI using VS Code