top of page
  • MK

Import VPAX Data into Tabular Editor

Updated: Aug 18, 2021

Having read the title of this post you may be inclined to think that I am repeating a previous post. However, this new post is the simply the counterpart to my other post.

The other post was about importing Vertipaq Analyzer data from a live-connected model into Tabular Editor. In this post, I am sharing a new script which imports Vertipaq Analyzer data from a .vpax file to Tabular Editor. The result of executing this script is the same in comparison to the script in the previous post. However, this script does not necessitate a connection to a server as all the necessary data exists 'offline' in the .vpax file.

What you need

  • .bim file or database.json file

  • Vertipaq Analyzer (.vpax) file (for the same model)


  1. Download the script.

  2. Paste the script into the Advanced Scripting window in Tabular Editor.

  3. Modify the vpaxFile parameter at the top of the script so that it is the location of your .vpax file.

  4. Click the play button (or press 'F5').

Just like that, the Vertipaq Analyzer data from the .vpax file has been loaded as annotations in Tabular Editor. And now, as with the other script, you can holistically check the integrity of your model via Best Practice Analyzer rules which reference these annotations. Enjoy!


Hello, when I follow the above I get Script executed successfully, 0 model changes. Any insights in what I am missing in my execution?

Replying to

Thank you so much, I missed the allow unsupported Power BI features setting.


Farhan, that probably means that your model is not processed. That error indicates that there is a partition with no segment count. Try processing your model, getting a new vpax file and running the script.


Farhan Soomro
Farhan Soomro
Feb 04, 2021

Mike I am getting division by zero error line 211

bottom of page