You can analyze a Power Pivot data model by importing it in Power BI Desktop.Īdded measures for segments and partitions: pageable, resident, refresh date, last access. Download version 1.93 for compatibility with Excel 2016 and Excel 2013. VertiPaq Analyzer requires Excel 2019 or Microsoft 365. VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Power BI and Analysis Services Tabular.Ī complete description and short tutorial are available in the article Data Model Size with VertiPaq Analyzer.