cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBIdeas
Frequent Visitor

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 IV
Super User IV

@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/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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.

View solution in original post

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors