Data modelling and DAX
Power BI doesn’t yet have a feature that allows end-users to turn on/off the ability to process calculations for visuals on a report page until they are ready. Most of the time, this is perfectly fine – however, in some instances, it can be handy to disable long-running and heavy calculations from running. At the … Continue reading Power BI – Pause/Resume calculations with Apply All feature
Have you ever wondered why a Power BI dataset refresh was taking so long? And more specifically, how much time did the refresh spend on various sub-tasks that aren’t that visible to you via the web-portal? This article shares a technique you can use to capture events fired during a Power BI refresh and use … Continue reading Visualise your Power BI Refresh
Last week I was honoured to take part in the latest edition of the Power BI Dev Camp which is run by my colleague Ted Patterson. It was a fun session which I enjoyed. As part of the Dev camp, I walked through some of my recent Visual Studio Code based blog posts on how … Continue reading DAX Formatter tool for Power BI Desktop
My last few articles have focused on using Visual Studio Code to build a series of scripts to help manage Analysis Services data models. As part of this work, I’ve found Visual Studio Code to be extremely helpful in other ways too, such as a very powerful text editor with many features you may find … Continue reading Use Visual Studio Code to Auto-format JSON
