Data modelling and DAX
Using DAX to help group and count the last known state I got asked recently to help with a DAX measure for an interesting problem in the inventory domain. The requirement is to generate a chart showing the count of the last known State of a given number of items. Here is a walkthrough of … Continue reading DAX : Count number of last known state
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
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
