Vpax Analysis
Model Storage & Performance Report
Analyze
Overview
Features
Prompts
Troubleshooting
Key Features
You export a VPAX file from DAX Studio and get raw numbers — column sizes, cardinality counts, encoding types. Is 500K cardinality too high? Is Value encoding on a string column a problem? Researching thresholds and manually flagging issues takes hours. This skill evaluates your model against 30 rules, flags violations by severity, and shows you exactly where your storage and performance issues are.
How it works
Extracts model metadata from the VPAX archive (ZIP containing JSON)
Evaluates 30 rules across 7 categories: model size, cardinality, encoding efficiency, relationships, column optimization, compression, and measures
Flags violations by severity with impact tags (Storage, Query, Refresh, Data Quality, Maintainability)
Builds supplementary data: top tables by size, top 20 columns by size with cardinality and encoding
What you get
Full report (.md) — all findings with affected objects
Compact report (.md) — summarized for quick review
Structured data (.json) — for automation
Top tables breakdown — row counts, sizes, percentages
Top 20 columns — cardinality, encoding type, dictionary vs data size
All files follow consistent naming: {project}_vpax_analysis_{date}_{time}.md
Explore more in this category
Best Practice Analysis
Analyze
Parse Tabular Editor BPA exports, match against 71 Microsoft rules, and generate a prioritized findings report.
Bookmark Analysis
Analyze
Simulate bookmark navigation, detect visual leaks, and fix show/hide issues across bookmark chains.
Color Analysis
Analyze
Extract every color assignment across all visuals, resolve theme colors to hex, and flag discrepancies.
Interactions Matrix
Analyze
Generate, edit, and compare visual interaction matrices showing who affects whom on each page.