IsAvailableInMDX: not just an Excel setting
Turning off IsAvailableInMDX can save memory, but it can also slow down a DAX query. A real text-filter example explains why this is not simply an Excel setting, and what to check before changing it.
Category: Power BI Refresh
Visualize Power BI Refresh using Semantic-link
A few blogs back I shared a technique using Power BI Profiler (or VS Code) to run and capture a trace over a refresh of a Power BI semantic model (the object formally known as a dataset). I’ve since received a lot of positive feedback from people saying how useful it was to visualize each … Continue reading Visualize Power BI Refresh using Semantic-link
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
Visualise your Power BI Refresh
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