Forum Discussion
PBIX file size problem
.My PBIX file size grew illogically and i'm not able to find out what is causing that size.
I even deleted all pages from the report and all datasets and relations... and the file still shows 4.2 MB on the filesystem.. which is causing me problems when trying to export it using the APIs.
here is the file
www.rubics.net/emptyfile.pbix.zip
can you please advise on why the file is still holding that size?
Got it!
Open the Layout 'file' in Notepad++ and you will see large swathes of image information, which looks like the scatter.jpg and other image artifacts that were actually in your Static Resources folder are actually baked into the Layout 'file' as well.
You should be able to avoid the issue if you start from scratch and are very selective about the images that you introduce. Alternatively, you may well be able to compare the Layout 'file' for a new blank pbix with the one you have, and scrape out the jpg and png junk that you don't want.
e.g
"scatter.jpg","name":"scatter.jpg","content":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABAAAAAJACAIAAACc94OCAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAACxIAAAsSAdLdfvwAAP+lSURBVHhe7J0FfBy38sfXSdM2Tdo0VKb3+l77ysxNm1IaZmZmZuaGmZmhScPM0DAzg0NOYmam/29mtLq989k+U5r2f9+PrZNGo9FIq9VKe3t3RqIbNw+W+HgJCXlFyDkpEZ8YhzCBkQiL00LaS2Qc+BkXR55PmLTw1u178RDEUWO5Ha46hC6CcnhE1IQlWyoNmF6iy7jb93wgiUlQpkRNQ6YTlBxhbBwLULNkpx2UVbGUUAdR6lK4WtYpttaxrQT0Q2w8GhHv7x9I44a7xaEKjqGgciZZLE5JlEyxHTle9wJDnusw59xtP5gCoiBZB8...
16 Replies
Hi msalam,
I downloaded the pbix file you shared with us, and also created a brand new pbix with Power BI Desktop myself. Then I extracted both files to Folders using Zip file tools. After comparing them within the folders, I found there is Layout file within "Report" folder which is mainly holding the size(about 4594 KB), and "CustomVisuals", "StaticResources" folders are also holding some of the size.
Regards
Thanks for your answer.
So that Layout file, how can we get rid or reduce its size? why is it still there when the actual report page is empty?
You can save 1.7MB if you delete out the icons in under the Static Resources directory. You save a bit more by removing the custom visualisations that are there as well.
I see what you mean about the Layout, it's large compared to a new file. I've tried deleting the page and adding a new one as I'm sure you have, to no effect.
It's interesting to look at the impact of various artifacts, can I ask why you need such a small file?
msalam I get a 404 file not found when accessing the link. Have you tried changing the PBIX extension to .zip? This will allow you to open the file and see where the size is being applied. You can change it back to a .pbix afterwards.
i fixed the file location adding .zip to it so you can download it
Hi,
I'm also getting the 404 error. If you can share the file again we can take a look.
I've recently had the same problem and my file size also grwe about 4Mb, from 1.6Mb to 5.7Mb after some small changes. Even after deleting all pages, leaving only an empty one and deleting all tables, except the fact table, the file size was 5.7Mbytes. I could never get back to the originally 1.6Mb file size.
It seems to by a Power BI bug, and the size increase is very similar to yours, which makes me believe that it's not only a specific image that was inserted and left as "undeletable trash".
