analyze_model_size
Get exact VertiPaq storage byte totals per table and the largest columns/objects to identify what bloats a Power BI model's memory and target efficiency fixes.
Instructions
Get VertiPaq storage engine byte totals per table (exact) and the largest individual storage objects/columns (best-effort labeling) -- the same underlying data DAX Studio's and Tabular Editor's VertiPaq Analyzer use to show what's bloating a model's memory footprint. Use this for efficiency review: a surprisingly large table or column here is a concrete lead (unused high-cardinality column, a text column that should be split or removed, importing more history than needed, etc).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | ||
| instance | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||