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.
Data modelling and DAX
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.
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
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
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