Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
A collegue has noted that Power BI file sizes (.pbix) were increasing after uploading to and then downloading from the service. This is despite no changes to the report or data being made. I ran a couple of tests to investigate.
I first tested using Excel data.
Initial saved as pbix: 42KB
Initial saved as pbit: 12KB
pbix after uploading and downloading from service
1st time: 430KB
2nd time: 430KB
3rd time: 430KB
Saving as pbit after 3rd time: 12KB
I tested again using a ODBC connection.
Initial saved as pbix: 584KB
Initial saved as pbit: 11KB
pbix after uploading and downloading from service
1st time: 1,787KB
2nd time: 1,787KB
Saving as pbit after 2nd time: 11KB
Going by what I've found is seems clear that uploading to the service and then downloading the .pbix results in an increase in file size which varies dependant on file size. Once this has been done initially the file size does not appear to change.
Does anyone know why this occurs? Can it be avoided?
Thanks and Kind Regards,
Calvin
hi, @Anonymous
When downloading the PBIX, the Power BI service has to rebuild the PBIX from scratch again.
There is maybe some little operation affect the size of new pbix file. This aThere is very little difference in size.
Best Regards,
Lin
Hey Lin,
Do you know any more about the process that is occuring?
In the second instance the file size more than doubled. Surely if this scales with file sizes then this could be quite a significant difference, especially if repeated.
Thanks,
Calvin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |