Forum Discussion
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
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.
6 Replies
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
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.
Or maybe you can unzip your pbix file and check which part takes up the most memory, please refer this article.
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.
