Topic: Optimization
Introducing the Power BI Performance Analyzer
This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports. Read more
Aggregations in Power BI
Aggregations have been introduced in 2018 in Power BI, as an optimization technique to manage large tables. By providing pre-aggregated tables, you can highly improve the performance of a Tabular data model. In this session we introduce the concept of… Watch now
Optimizing IF and SWITCH expressions using variables
This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. Read more
Optimizing DAX with cardinality estimation: computing working days
Estimating the cardinality of iterators is an important skill when optimizing DAX code. This article explains how to use this technique, evaluating different ways of computing the number of working days between two dates. Read more
Optimizing nested iterators in DAX
This article describes possible optimization approaches to improve the performance of nested iterators in DAX. Read more
Power BI DAX optimization examples
How can you optimize your DAX expressions? In this session, we’ll analyze DAX expressions and Tabular models, then utilize DAX Studio and the VertiPaq model to explore how to optimize them. While most optimizations are the direct application of best… Watch now
Optimizing mutually exclusive calculations
This article describes how to optimize DAX expressions with mutually exclusive calculations that might cause slow query performance. Read more
My Power BI report is slow: what should I do?
You have created a wonderful looking Power BI report, but when you open it you find it is not rendering as fast you want. This session covers where should you start analyzing the problem and what can you do to… Watch now
Optimizing IF conditions by using variables
This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX. Read more
Capturing Power BI queries using DAX Studio
This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand performance issues, and to improve the writing of DAX queries. Read more