VertiPaq Analyzer

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular.
A complete description and short tutorial is available in the article Data Model Size with VertiPaq Analyzer.

You can analyze a Power Pivot data model by restoring it in Analysis Services.
The current version is not compatible with the Power BI Designer data model.

UPDATE 2015-09-27: Version 1.3 now handles correctly renamed tables and renamed columns in the data model.

UPDATE 2015-11-26: Version 1.4 now includes encoding type and it fixes column names if they have been renamed in the data model.

UPDATE 2015-12-31: Version 1.5 fixed a small issue displaying the combination of table-column name in a single column, which was displaying column id instead of column name in ColumnKey attribute. Now we use TableColumn attribute in Columns worksheet.

UPDATE 2016-06-26: VertiPaq Analyzer does not report correctly the column size for database in compatibility model 1200 deployed in Analysis Services 2016 RTM (build 13.0.1601.5) – this is caused by a bug in Analysis Services, we are waiting for a fix from Microsoft.

UPDATE 2016-08-28: Version 1.6 fixed an issue displaying column’s cardinality in Columns worksheet. Microsoft fixed the issue of compatibility models 1200 in Power BI Version 2.38.4491.282 (August 2016). Still waiting for a fix for Analysis Services 2016 RTM.

UPDATE 2016-09-22: Microsoft fixed the bug of DMV in SQL Server 2016 RTM CU2. Now VertiPaq Analyzer 1.6 works correctly also with SSAS Tabular models in compatibility level 1200.

UPDATE 2017-01-15: Version 1.7 introduce two models, one for compatibility level 1103 (SSAS 2012/2014) and one for compatibility level 1200 (Power BI/SSAS 2016). The latter shows more information about relationships and a complete list of measures, calculated columns, and calculated tables, including their DAX expressions that can be formatted with a single click (code borrowed from Power Pivot Utilities for this feature – thanks Bertrand! Read more in the updated article Data Model Size with VertiPaq Analyzer.

UPDATE 2017-05-30: Version 1.8 fixed minor issues in calculation, in particular for evaluation relationships’ size.

UPDATE 2017-08-08: The ZIP file includes Version 1.8 for Excel 2016 and version 1.6 for Excel 2013. The 1.8 version works for compatibility levels 1200 or higher.

Download (ZIP)


 Enclose code in comments with <PRE></PRE> to preserve indentation.