Topic: VertiPaq
-
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
-
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
-
UPDATE 2021-06-29: also read Choosing Azure Analysis Services or Power BI Premium for large datasets – SQLBI containing updates about Power BI Premium Gen2. I often get questions about use cases for Azure Analysis Services. So I wanted to do… Read more
-
After you apply all the best practices to improve compression in Power BI, you can play with advanced settings to increase it further, even though this can affect certain features. Explore how to manipulate Encoding Hint and Available In MDX… Watch now
-
Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views. Read more