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

6 Replies

  • 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
         
    • Sujith12345's avatar
      Sujith12345
      Helper I
      4 years ago

      timg @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.?

      • timg's avatar
        timg
        Solution Sage
        4 years ago

        Hi Sujith,

        Most options will involve changing/optimizing your datamodel. If no columns can be removed you could still look at:

        • reducing the number of rows in each table (e.g. instead of loading multiple years of data, just loading the current year)
        • If you have calculated columns, you could try moving those to Power query instead
        • Limit the number of unique values within columns that currently have many unique values (e.g. by grouping them in Power query or the source)

        Regards,

         

        Tim