Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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 , 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
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.
User | Count |
---|---|
95 | |
89 | |
70 | |
63 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |