Forum Discussion
Power Pivot data model file size
Good question on which I have no direct answer, if only not to play with concrete file. In general, in behind of Power Pivot is VertiPaq engine, which has the same logic for any tabular model - Power Pivot, Power BI, etc. It has formula engine and storage engine, the latest transforms raw data into data cache with which data model works. Exact algorithms is Microsoft proprietary information which is not shared. However, lot of materials around. VertiPaq optimization steps are briefly described here Vertipaq optimization and its impact on columnstore compression - Simple Talk (red-gate.com) , on each step that could be chosen different algorithms.
From practical point of view I'd install DAX Studio (it's free) and check in View Metrics -> VertiPaq Analyser what has significant impact on this or that case. In any case that's not liner dependency on rows number.
One of useful posts is Optimizing High Cardinality Columns in VertiPaq - SQLBI , but again, it's lot of them. Just first what found.
