Question

You maintain an imported Power BI semantic model that has grown to 1.2 GB, causing slow refreshes and high memory use. Before removing anything, you want to identify which specific columns consume the most storage so you can target the largest offenders. Which approach gives you the most precise, column-level size breakdown?

Accepted Answer

Run VertiPaq Analyzer (via DAX Studio or the model's memory statistics) to view the size in bytes of each column, table, and dictionary

Answer

Use Performance Analyzer to capture the DAX query duration for each visual on the report canvas

Answer

Open Column quality and Column distribution in Power Query to review the percentage of valid and unique values

Answer

Enable Assume referential integrity on each relationship to compress the model automatically