Topic: VertiPaq
-
We recently released the second edition of the Optimizing DAX video course. Despite its volume, some details always did not find space in the training material. The REDUCED BY syntax of xmSQL is one of those details. Read more
-
The second edition of the Optimizing DAX video course is available: new content, a new book, and some on the behind-the-scenes of the project. Read more
-
This article describes how to implement a DAX measure to run faster than what you get from the built-in fusion optimization. Read more
-
How to implement a DAX measure to run faster than what you get from the built-in horizontal fusion optimization. Watch now
-
There are cases where the dictionary size reported by VertiPaq Analyzer (used by DAX Studio, Bravo for Power BI, and Tabular Editor 3) does not correspond to the actual memory required by the dictionary. However, the number reported is technically… Read more
-
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
-
Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this article, we introduce this optimization with some examples. Read more
-
It is not common to face rounding differences in Power BI. However, when it happens, users are usually disappointed and surprised. Read more
-
We recently discussed an issue related to the Dictionary size reported by Bravo for Power BI that, in reality, references the behavior of VertiPaq Analyzer, which relies on data management views (DMV) provided by the underlying Analysis Services engine. Because… Read more
-
Discover the pros and cons of disabling attribute hierarchies in Power BI and Analysis Services by modifying the “Available in MDX” property. We will analyze the difference in memory and performance that you can obtain by modifying a Power BI… Watch now
