File size increased five times

[Anonymous]

Hello,

I made some apparently minor changes to my model by adding two new tables (each with 2 columns and 4 rows), and then referencing them in the main table by adding two calculated columns (basically assigning values 1 through 4 based on category). There is a one to many relationship between these two newly created tables and the main table.

This change alone made my file size increase from 10MB to 57MB and I am not sure why. I read somewhere that disabling "Auto Date/Time" helps reduce the file size and once I did that it reduced it to 4MB however one of the measures had an error since it relied on the date hierarchy created by Power BI automatically.

Any other ideas what I could do to reduce the file size to be close to the original file size of 10MB? Is it possible that just adding two small tables and adding two calculated columns in the main table can increase file size 5 times?

Thank you!

[amitchandak · Accepted solution]

@Anonymous , refer to these video from guyinacube, see if they can help more

https://www.youtube.com/watch?v=RnDdDlozcdo

https://www.youtube.com/watch?v=vrgeDfO8RXQ

https://www.youtube.com/watch?v=c-ZqToc85Yc

[Anonymous]

Thanks!

I think I found the problem as described in one of the guyinacube videos. Updated dataset has a year value 9999 while the old version went only up to 2030. This most likely caused the file increase since auto date/time had to generate a lot more dates than in the previous version.