Which column type typically consumes the most memory in a Power BI model?
- A High-cardinality columns such as GUIDs or timestamps to the second
- B Boolean columns
- C Short text columns with few distinct values
- D Integer keys with low cardinality
Answer
High-cardinality columns such as GUIDs or timestamps to the second
VertiPaq compresses by distinct value, so splitting a datetime into separate date and time columns often shrinks a model dramatically.





