How to Reduce the Size of Power BI file in a few Steps

[@abhishekstatus_7]

Thanks for this Reza, Excellent tool and explanation.

[@spyrosvlachos8834]

Hi, the Visualization tab is empty even though I am connecting to the model. Any possible solution?

[@OlsoNounas]

Hi Reza, thank you for creating this tool. I will be sure to download it now. Question: Can the tool help us see which measures aren't being used in the report? That would be extremely helpful.

[@RADACAD]

Yes, it does and can remove them too

[@OlsoNounas]

@@RADACAD Fantastic 😎 thank you

[@cropereira]

Excelent video. Question. How big was the biggest dataset you have ever worked in Power BI? I am talking about number or fact rows

[@RADACAD]

over trillions of rows. but I wouldn't import that size of data of course. leveraging composite model and aggregations.

[@abderraoufseghir1165]

amazing video! thanks for the clear and concise explanation. I disabled auto date time for my model that has a size of 130 MB and it went all the way down to 3MB. I had a ton of dates since my report is mainly focused on planning and scheduling for product launches with multiple milestone dates so I guess it's natural for it to shrink but I didn't think it would shrink that much. I have a custom date table and it had the hierarchy for the year - quarter - month - week - day....but I can no longer find the hierarchy on my date table, is that normal? also one of my visuals i can go down multiple levels into the hierarchy to different timeframes and it is still working despite not having the date hierarchy on the fields, is that a normal behavior? Thanks in advance for the reply!

[@olozmada]

I love your tool. What happened in the background when you deleted the unused columns?

[@RADACAD]

what do you mean by "What happened in the background"? the removal of the columns you mean from the Power BI file?

[@MultiAllaeddine]

Great tool, helpful content

[@RADACAD]

Glad to hear that!

[@deb73268]

Good