Category: Optimise

The Impact of Primary Keys on DAX Query Performance in Power BI

Posted on 1 Comment on The Impact of Primary Keys on DAX Query Performance in Power BI

When writing DAX queries, performance tuning often comes down to small design decisions that have big consequences. One such decision is whether to include Primary Key columns from Dimension tables in your SUMMARIZECOLUMNS statements. This is particularly important when those Dimension tables use DUAL or IMPORT storage modes. This article explains why doing so can … Continue reading The Impact of Primary Keys on DAX Query Performance in Power BI

How to Generate a DAXX File for Performance Tuning

Posted on 1 Comment on How to Generate a DAXX File for Performance Tuning

When troubleshooting slow DAX queries, sharing the right diagnostic information with an expert can make all the difference. That’s where a DAXX file comes in. This special file format is created using DAX Studio. It bundles essential metadata and performance details without exposing query results. It’s perfect for collaborative optimisation. What is a DAXX File? … Continue reading How to Generate a DAXX File for Performance Tuning

Direct Lake Performance Gets a Boost: Faster Join Index Creation

Posted on 1 Comment on 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

Posted on 4 Comments on 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