Forum Discussion

Sujith12345's avatar
Sujith12345
Helper I
4 years ago

File size

Hi all,  My excel file(source fie) size is 28mb and pbix file size is 80mb.I need to reduce my pbix file size. Suggest some idea. 
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey Sujith12345 ,

 

that can have many reasons.

Best approach is take DAX Studio, connect to your Power BI file and check the metrics with the vertipaq analyzer:

 

When you get the result, take a look which columns take a lot of space, check if they have the right type. If you don't use them at all remove them from the data model. Like this you can go step by step to improve your file.

 

Also I highly recommend to read the article from Nikola Ilic, so much knowledge about that topic:

How to reduce your Power BI model size by 90%! - Data Mozart (data-mozart.com)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
Sujith12345's avatar
Sujith12345
Helper I
4 years ago

selimovd @Already I tried with uncheck the date/ time option and based on the client requirements, they don't want to remove any columns in the report

 

Is there any possible way to reduce power bi size.?

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    Hey Sujith12345 ,

     

    did you also check if they have the proper format?

    If they have all the right format and they don't want to remove any columns, then it will stay the same.

     

    The only way you could try is to replace columns with measures. For example if a column is multiplying 2 other columns, you could replace it with a SUMX measure.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis