VertiPaq Analyzer 2.0 is an open source project available on GitHub that includes several libraries made available on NuGet, enabling the integration of VertiPaq Analyzer features in different tools. These are the libraries available:
- Dax.Metadata is a representation of the Tabular model including additional information from DMV and statistics about data distribution in the model. This is a .NET Standard library without dependencies on the Tabular Object Model (TOM). This is the core of VertiPaq Analyzer and includes all the information about the data model in a format that will allow a complete anonymization of the data model in a future release.
- Dax.Model.Extractor populates the Dax.Metadata.Model extracting data from a Tabular model. This library depends on TOM and .NET Framework 2.7.1.
- Dax.ViewModel provides a view over Dax.Metadata.Model data that can be integrated in applications using the view model, such as the one implemented in DAX Studio (use DAX Studio 2.9.3 or later version). This library is a .NET Standard library.
- Dax.ViewVpaExport exports the Dax.Model for the consumption in VertiPaq Analyzer 2.0 client tools. This library is a .NET Standard library.
- Dax.Vpax supports the VPAX format.
Using the VertiPaq Analyzer libraries, a client tool can easily extract the information from a Tabular model, export them in a standard file, and read the same information for visualization purposes.
The sample of missing keys of a relationship (Relationship.SampleReferentialIntegrityViolations) is available only to a tool connected to the model: it is not saved in a VPAX file, to avoid exposing data, so it is empty when the model is read from a VPAX file.
VPAX Format
The VPAX file format is a ZIP file containing the following files:
- DaxModel.json is a serialization of the Dax.Metadata.Model.
- DaxVpaView.json is a serialization of the Dax.ViewVpaExport that is used to import data in the VertiPaq Analyzer 2.0 Excel file using a specific macro. Its rows follow the order of the model in DaxModel.json, table by table, and they are not sorted.
- Model.bim is an optional file that exports the complete model in TOM format. This file is not used by current client tools, but it could be useful for future extensions.
- CompatabilityMode.txt is written together with Model.bim and contains the compatibility mode of the database (for example, PowerBI), used to read Model.bim. The name of the part is spelled CompatabilityMode.txt, and readers must use this spelling.