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: Data Modelling
Direct Lake Performance Gets a Boost: Faster Join Index Creation
If you’ve been working with Direct Lake in Microsoft Fabric, you’ll know its magic resides in its ability to quickly load data. It loads data into semantic models from OneLake when needed. This feature eliminates the overhead of importing. But until recently, the first query on a cold cache might feel sluggish. Why? One reason … Continue reading Direct Lake Performance Gets a Boost: Faster Join Index Creation
Speed up Distinct Count calculations in Power BI using Aggregations
This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well … Continue reading Speed up Distinct Count calculations in Power BI using Aggregations
Using PowerShell to create Calculation Groups in Power BI Desktop
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