Forum Discussion

msalam's avatar
msalam
Frequent Visitor
9 years ago
Solved

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...
Need Help
Show and Tell
  • Brian_M's avatar
    Brian_M
    9 years ago

    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...

msalam's avatar
msalam
Frequent Visitor
9 years ago

Indeed it should be the basic responsibility of Power BI Desktop.

 

Although we agree that your solution is a workaround, yet it would be a night mare to effectively open that file and try to eliminate all redundant data from it when that file is fully loaded with real usefull reports unlike our scenario an empty file.