Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PBIdeas
Advocate I
Advocate I

Model size remains the same after removing data

Hi,

 

I removed all data within a PowerBI model but the overall model size remains roughly the same (8Mb from 11Mb). However, if I create the same model from scratch it's only 541kb. 

 

Thanks 

1 ACCEPTED SOLUTION

Hi @PBIdeas ,

 

If you delete all pages and buttons, how much the size of the file will become?

Or you can change your file suffix to Zip and unzip it, check the Layout file. Maybe this file is the point.

Please refer this post,

 

https://community.powerbi.com/t5/Desktop/PBIX-file-size-problem/td-p/87416

 

Best regards,

 

Community Support Team _ zhenbw

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

View solution in original post

6 REPLIES 6
amitchandak
Super User
Super User

@PBIdeas , In a model, if you create new calculated columns, tables, load more data. All will account. Plus once you create visual that will add to file size.

 

refer how to check size

https://www.xylos.com/en/learning/blog/power-bi-check-memory-usage-of-model-with-vertipaq-analyzer

https://www.youtube.com/watch?v=c-ZqToc85Yc

https://powerdax.com/power-bi-model-analyzer/

The model does not contain any data (I will connect it later to a PowerBI dataset), so I don't see how this can be a performance issue as there are no data/calculations in there.

 

I would start over but there's some navigation funtionalities there that I would like to avoid re-doing from scratch but that's it in terms of contents of model at this point.

 

 

 

Hi @PBIdeas ,

 

What data source are you connected to, and what is the connection mode?

 

Do you have many date/time columns in your model?

Maybe you can turn this off in options.

 

M1.jpg

 

Or maybe you can unzip your pbix file and check which part takes up the most memory, please refer this article.

 

M2.jpg

 

https://www.fourmoo.com/2017/05/02/what-makes-up-a-power-bi-desktop-pbix-file/

 

If you have any question, please kindly ask here and we will try to resolve it.

 

Best regards,

 

Community Support Team _ zhenbw

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

Hi,

 

I am not connected to any data, that's the whole point. Let me go through the steps:

 

1. Original model (11Mb)

2. Removed all data sources and visuals taking the file size to 8Mb. At this point, the model only includes a cover page and some 15 blank pages with some action buttons

3. Created the same model as 2. from scracth which only gives me a file size under 1Mb

 

Step 2. is done in advance of linking the model to a PowerBI dataset but this has done be done yet. 

 

Thank you.

 

Hi @PBIdeas ,

 

If you delete all pages and buttons, how much the size of the file will become?

Or you can change your file suffix to Zip and unzip it, check the Layout file. Maybe this file is the point.

Please refer this post,

 

https://community.powerbi.com/t5/Desktop/PBIX-file-size-problem/td-p/87416

 

Best regards,

 

Community Support Team _ zhenbw

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

Hi,

 

If I remove everything (minus the cover and navigation buttons) the file goes down to the 8Mb which I mentioned initially. 

 

As I read the post shared, the solution is basically starting over which I did. It's not the most efficient approach but the underlying data is proprietary and cannot be shared outside my Organization.

 

Thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.