This article explains the roles of the formula engine and of the storage engine used to execute DAX queries.  Read more

Power BI has an integration with external tools that can provide additional features and improve the productivity of report authors. In this session we see how this integration works and we analyze a few popular external tools like DAX Studio,…  Watch now

DAX Studio is the best tool to analyze the performances of DAX queries. In this webinar recorded for powerbi.tips, Marco Russo shows how to collect metrics in DAX Studio and investigate on storage engine and formula engine cost of some…  Watch now

VertiPaq Analyzer is a set of tools and libraries to analyze VertiPaq storage structures for a data model in Power BI and Analysis Services Tabular. In this webinar recorded for powerbi.tips, Marco Russo shows how VertiPaq Analyzer has been integrated…  Watch now

I often get questions about use cases for Azure Analysis Services. So I wanted to do a quick recap of the points I commonly discuss in these conversations, and have them readily available for the next conversation… As a bonus,…  Read more

In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used with Analysis Services and Power BI.  Read more

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Power BI and Analysis Services Tabular. A complete description and short tutorial are available in the article Data Model Size with VertiPaq Analyzer. You can analyze…  Free download

This article compares the differences between calculated columns and calculated tables from a processing and storage point of view.  Read more

This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular.  Read more

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular. Learn how to connect VertiPaq Analyzer to Power BI and to SSAS Tabular, and see quick overview of the features available. Then, download…  Watch now