THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

VertiPaq Analyzer 1.7: a fundamental tool for #powerbi #powerpivot #ssas #tabular diagnostics and documentation

If you work with Power Pivot, Power BI, or Analysis Services Tabular, you probably already know VertiPaq Analyzer. If you never used it, with the new release 1.7 you have another couple of very good reason to try it.

VertiPaq Analyzer is a Power Pivot workbook that extracts information from data management views (DMVs) of a Tabular model. It can be connected to a SSAS Tabular or a Power BI database. If you have a Power Pivot data model, just import it in Power BI and extracts the information from there. You will quickly see what are the tables and columns that are more expensive, and you will have all the details about cardinality of columns and tables at a glance. This is of paramount importance when you have to optimize a DAX expression. However, these are the features we already had in VertiPaq Analyzer. What’s new in this release?

  • There are two versions of the VertiPaq Analyzer, which is an Excel file with VBA macros now (for the new VertiPaq Analyzer ribbon)
    • The version with suffix 1103 uses the “legacy” DMVs for Multidimensional
    • The version with suffix 1200 starts using the new DMVs for Tabular (which are available only for compatibility level 1200 – more on that in this article.
  • There is a ribbon for VertiPaq Analyzer that includes a button to format all the DAX expressions:
    DMV Size 13
  • And yes, there are three new worksheets that show all the measures, calculated columns, and calculated tables extracted from the data model, each one with its own DAX expression
  • Last but not least, the Relationships worksheet shows in a clear way the tables and columns involved for each relationship, including two measures about the maximum cardinality of the columns involved in the relationship.

This tool is amazing to do remote troubleshooting, or even just to document what are the DAX formulas you have in a model at a given point in time. It saves me hours every week. I hope it will be useful to you, too!

Published Monday, January 16, 2017 2:34 PM by Marco Russo (SQLBI)



Uri Dimant said:

Hello Marco

I downloaded DAX studio by cannot connect to PBI, it is just greyed  and the only option is to connect to Tabular SSAS.  

January 17, 2017 1:11 AM

Uri Dimant said:

Hi Marco

Please ignore the previous message , I managed  to connect to PBI


Is  that possible by this tool to  capture users who runs the PBI reports?

January 17, 2017 4:26 AM

Marco Russo (SQLBI) said:

No, it is not possible - you have to look at DAX Studio for that.

January 19, 2017 10:51 AM

Mike Ed said:

How were you able to get connected I download VertiPaq Analyzer, however I can not figure out how to connect to a Power BI Model. The process for updating the data connection isn't working

January 20, 2017 2:48 AM

Marco Russo (SQLBI) said:

February 15, 2017 12:12 PM
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement