Topic: Optimization
-
GROUPBY and SUMMARIZE seem similar, but they differ in both performance and functionalities. Choose the right one depending on specific scenarios! Watch now
-
Optimize the query performance of a SWITCH function in DAX that reads a slicer selection: the Group By Columns property can solve a practical problem. Watch now
-
Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this video, we introduce this optimization with some examples. Watch now
-
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Watch now
-
Learn why you should use ADDCOLUMNS in DAX to compute aggregations instead of doing that inside SUMMARIZE: performance can be very different! Watch now
-
In composite models, any query can be executed on the remote model (wholesale execution) or by mixing local and remote engines together (retail execution). This video describes the differences between the wholesale and retail modes in composite models. Watch now
-
Analyze and measure the performance of an alternative data modeling solution suggested by Daniel Otykier (author of Tabular Editor) regarding the article Different options to model many-to-many relationships in Power BI and Tabular. Which solution is faster? Or “it depends”?… Watch now
-
DAX Studio 2.17 introduced improved server timings features to analyze the parallelism of storage engine operations. Watch now
-
Large models in Power BI Premium have now a larger segment size like Analysis Services. Is this important? Does it improve compression or performance? When? This unplugged video shows the early tests and benchmarks, in preparation for a future and… Watch now
-
Follow the process of optimizing a measure created in a previous unplugged to display the distribution of the distance between transactions in a column chart. Many people who have seen the previous unplugged asked for this second episode to discover… Watch now