cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

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?

3 REPLIES 3
Advocate II
Advocate II

@jcapezzuto

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

Thanks,

Alix 

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.

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors