Which external tool can show the size of each table and column in a model?

Which external tool can show the size of each table and column in a model?

• A. ALM Toolkit
• B. DAX Studio
• C. Metadata Translator
• D. PowerBI.tips - Business Ops

Answer: (B)

External tools that can query a model’s internal metadata are the way to see exact storage footprints. DAX Studio connects to your Power BI or Analysis Services model and lets you run native DMVs to pull storage data. By querying DMVs like DISCOVER_STORAGE_TABLES you get per-table size (and row counts), and DISCOVER_STORAGE_COLUMNS can give you per-column storage details. This makes it easy to spot large tables or columns that are driving memory use and plan optimizations such as removing unused columns or aggregations. The other tools aren’t built for this specific task: ALM Toolkit is geared toward application lifecycle and schema comparison, Metadata Translator focuses on metadata format translation, and PowerBI.tips is a learning site rather than a tool for inspecting model storage.

External tools that can query a model’s internal metadata are the way to see exact storage footprints. DAX Studio connects to your Power BI or Analysis Services model and lets you run native DMVs to pull storage data. By querying DMVs like DISCOVER_STORAGE_TABLES you get per-table size (and row counts), and DISCOVER_STORAGE_COLUMNS can give you per-column storage details. This makes it easy to spot large tables or columns that are driving memory use and plan optimizations such as removing unused columns or aggregations.

The other tools aren’t built for this specific task: ALM Toolkit is geared toward application lifecycle and schema comparison, Metadata Translator focuses on metadata format translation, and PowerBI.tips is a learning site rather than a tool for inspecting model storage.