Power BI

[SivaKishor289]

What are the best practices for reducing the size of a PBIX file ?

[v-yangliu-msft · Accepted solution]

Hi  @SivaKishor289 ,

@Thanks for the reply from @Idrissshatila , please allow me to provide another insight: 

You can try the following：

1. Reduce file size, you need to remove unneeded data, for example, please find and remove columns that contain a lot of text, Notes field is a big performance killer, will increase the pbix file size, then load fewer rows or remove unneeded columns
2. Filter the query by date and other fields, there is no point in storing historical data for the last 5 years if only the last 3 months are visualized in the pbix.
3. Disable the Auto Date/Time option for data loading (this will remove a bunch of automatically created date tables in the background).
4. Disable Power Query query load.

Refer to:

Data reduction techniques for Import modeling - Power BI | Microsoft Learn

You can use tools such as DAX Studio to see what is taking up space in your model:

https://daxstudio.org/

https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/

This is the related document, you can view this content:

https://pragmaticworks.com/blog/power-bi-performance-tips-and-techniques

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

https://www.xavor.com/blog/how-to-reduce-the-size-of-power-bi-pbix-file/

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila]

Hello @SivaKishor289 ,

check this article, it summarizes all of the best practices https://www.linkedin.com/pulse/power-bi-optimization-framework-ahmad-chamy-nensf%3FtrackingId=ucnXKz...