What is model size optimization?

< 1 min read

Model size optimization means reducing the memory footprint of the data model to improve performance.
It involves removing unnecessary columns and unused tables.
In one project, I removed 15 unused columns from a fact table to reduce size.
I also changed data types from Text to Whole Number where possible.
High-cardinality text fields were avoided unless required for reporting.
Calculated columns were replaced with measures when possible to save storage.
Optimizing model size improves refresh time, report speed, and overall scalability.

Power BI Essentials