Forum Discussion
WishAskedSooner
Continued Contributor
Continued ContributorPBIX is HUGE!
Hi Experts! I have a new model I have been building, and it keeps ballooning in size. It is nearly 100 MB, and I have no idea why. It is only 10M rows of data. I have another model that has about...
danextian
Super User
Super User
Things that normally increase a semantic model's footprint:
- auto datetime - this creates and invisible dates table for each date column
- datetime- this usually results to a very high cardinality column. Consider splitting them into date and time elements. If you don't need the time, just parse the the date. If you don't need the minutes, just pick the hour. You will want a smaller distinct count of values for each column.
- unneeded columns
- uncessary calculated columns
I would consider using Measure Killer tool to identify elements in your model that can be removed.