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

File sizes increasing after uploading to and then downloading from the service.

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

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: File sizes increasing after uploading to and then downloading from the service.

hi, @calvinisme 

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

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
calvinisme Frequent Visitor
Frequent Visitor

Re: File sizes increasing after uploading to and then downloading from the service.

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 47 members 1,174 guests
Please welcome our newest community members: