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.
Tag: Performance
Use Column Splitting to optimise Power BI semantic models
An established modelling technique for a large numeric column you mostly SUM. Lower-cardinality components can reduce memory and loading costs, but smaller dictionaries do not guarantee cheaper queries. Here is the recipe and what to measure before keeping it.
Power BI calculation groups just got faster to compile
An optimisation has shipped in the Power BI semantic model engine that cuts the time spent preparing a query that uses calculation groups. It happens before any data is read, so it will not speed up your scans. Some models will barely notice. Models with several calculation groups that reference each other could see a lot. Here is what was happening, why it was written that way, and how to work out which camp you are in.
Optimize Your Power BI Model: Use COUNTROWS for Distinct Counts
DISTINCTCOUNT over a high cardinality transaction ID is one of the most expensive things you can ask the storage engine to do. If you understand which of your dimensions have a functional dependency on that ID, you can answer a large share of your queries with a plain COUNTROWS instead, and shrink the work for the ones that are left.