Forum Discussion

jcapezzuto's avatar
jcapezzuto
Icon for Resolver I rankResolver I
10 years ago

PBIX file size increase

I've noticed that my PBIX files have almost doubled in size after downloading the November desktop update and refreshing the data.  Were the files upgraded or something that would have left them fragmented?

Need Help

3 Replies

  • Aroth's avatar
    Aroth
    Icon for Advocate II rankAdvocate II
    9 years ago

    jcapezzuto

    Hello, I just had the same issue... 
    Did you find a way to solve it ? 

    Thanks,

    Alix 

    • jcapezzuto's avatar
      jcapezzuto
      Icon for Resolver I rankResolver I
      9 years ago

      Hi Aroth no I did not find a solution, but the increased file size only occurred once after that particular upgrade and the file itself still worked correctly.

      • Phil_Seamark's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Are you sure there were no in-model changes that could have caused this?  Sometimes, simply adding a single column to a large table can have this effect if there is a high degree of uniqueness.

         

        You can run some DMV queries against your model to see exactly where the memory is being used.  I find this quite an effective way to optimise PBI desktop model sizes.