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.
VertiPaq Analyzer requires Excel 2019 or Microsoft 365. Download version 1.93 for compatibility with Excel 2016 and Excel 2013.
You can analyze a Power Pivot data model by importing it in Power BI Desktop.
Latest changes
v2.1.1
Fixed “Access denied” error invoking DAX Formatter
v2.1.0
Added measures for segments and partitions: pageable, resident, refresh date, last access.
The new columns are supported in VPAX files exported by VertiPaq Analyzer libraries 1.20 (supported in DAX Studio 2.17.4).
v2.0.2
Fixed bug in syntax coloring (Format DAX Expressions).
Minor improvements to layout and default settings.
v2.0.1
Added support to 1:M Ratio % in Relationships supported by DAX Studio 2.13.2 or later versions.
v2.00
Version 2.00 is like Preview 6, it only refined instructions and added a message box once the VPAX file read completes.
Use it with DAX Studio 2.13.1 or later versions.
v2.00 Preview 6
Version 2.00 Preview 6 refined the visualization of the Relationship page based on survey, and added measures for relationships with bidirectional filter and many-to-many cardinality (MMR) in the Table view.
We suggest to export VPAX files with DAX Studio 2.13.1 or later versions.
v2.00 Preview 5
Version 2.00 Preview 5 improved the visualization of the Relationship page, showing the filter direction and the cardinality of the tables involved in each relationship.
Thanks for the feedback provided during preview 1, 2, 3, and 4.
We suggest to export VPAX files with DAX Studio 2.13.1 or later versions.
v2.00 Preview 4
Version 2.00 Preview 4 added the number of missing keys and invalid rows on the many side of a relationship (these numbers are exported to VPAX format by DAX Studio 2.11).
Thanks for the feedback provided during preview 1, 2, and 3.
We are now confident in data exported by DAX Studio 2.10.1 or later versions.
v2.00 Preview 3
Version 2.00 Preview 3 has one tab to display partitions grouped by tables.
Thanks for the feedback provided during preview 1 and 2.
We start to be confident in data exported by DAX Studio 2.10.1.
v2.00 Preview 2
Version 2.00 Preview 2 only imports VPAX files generated by DAX Studio 2.9.4 or later versions.
The preview 2 supports RI violations information saved in VPAX files by DAX Studio 2.10.1 or later versions.
v2.00 Preview 1
Version 2.00 Preview 1 only imports VPAX files generated by DAX Studio 2.9.4 or later versions.
Feedback is welcome during preview, there could be bugs and tests have been limited so far.
Use v1.93 for production.
v1.93
Version 1.93 only fixes an issue in table with role base security expressions in 1200 compatibility level.
v1.92
Version 1.92 only fixes an issue in table with role base security expressions (1200 only) that was not working correctly in certain versions of Analysis Services.
v1.91
Version 1.91 imports the filter expressions for role base security (1200 only).
v1.9
Version 1.9 fixed issues managing relationships created with Tabular Editor (1200 only) and improved syntax error handling calling DAX Formatter.
v1.8
Version 1.8 fixed minor issues in calculation, in particular for evaluation relationships’ size.
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.
v1.7
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.
v1.6
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.
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.
v1.5
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.
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.
v1.4
Version 1.4 now includes encoding type and it fixes column names if they have been renamed in the data model.
v1.3
Version 1.3 now handles correctly renamed tables and renamed columns in the data model.