Topic: VertiPaq
-
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
-
This article explains the roles of the formula engine and of the storage engine used to execute DAX queries. Read more
-
This article contains a short checklist of what you have to do in order to optimize the memory used by a data model in PowerPivot or in Analysis Services Tabular, including links to tools and resources that can help you… Read more
-
Hardware and virtualization settings have a big impact on Analysis Services Tabular performance. This article describes best practices for the most important settings to check. Read more
-
Choosing the right hardware is critical for a solution based on Analysis Services Tabular. Spending more does not always mean having a better machine. This short article describes how to choose the right server and, as you will see, the… Read more
-
The DIVIDE function in DAX is usually faster to avoid division-by-zero errors than the simple division operator. However, there are exceptions to this rule, described in this article through a simple performance analysis. Read more
