cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Pbix File Size and txt file size

I have a dataset in the txt file with size approx 3 GB.
Data is tab separated.
I have loaded this data in the power bi Desktop, But the size of the Pbix file is only approx 300 MB. How could is this possible?
There is no other way, with which I can validate data.
Is power bi shrinks the txt dataset or Power bi not loading whole data in the power Bi desktop?
Please help me with this.
Below is attach screenshot for Dataset file size and power bi File Size.

FilesizesFilesizes

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

Don't worry about this, when you import data (Get data->Text) to Power BI Desktop, all data from this file is imported into Power bi cache.

Why the size of Power bi saved file is smaller that the source file's is due to compression feature in Power bi.

 

Power BI leverages compression engine of xVelocity and works on a Column-store in-memory technology. Column store in-memory technology compresses data and stores it in a compressed format. Sometimes you might have a 1GB Excel file, and when you import it into Power BI, your Power BI file ends up with only 10MB. This is mainly because of compression engine of Power BI. 

 

Best Regards
Maggie

 

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

View solution in original post

3 REPLIES 3
mxd
Frequent Visitor

Hi there,

does the compression also work once the pbix file is published to Power BI Service?

For example once published the dataset size will be 300mb or 3gb?

v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

Don't worry about this, when you import data (Get data->Text) to Power BI Desktop, all data from this file is imported into Power bi cache.

Why the size of Power bi saved file is smaller that the source file's is due to compression feature in Power bi.

 

Power BI leverages compression engine of xVelocity and works on a Column-store in-memory technology. Column store in-memory technology compresses data and stores it in a compressed format. Sometimes you might have a 1GB Excel file, and when you import it into Power BI, your Power BI file ends up with only 10MB. This is mainly because of compression engine of Power BI. 

 

Best Regards
Maggie

 

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

View solution in original post

Anonymous
Not applicable

@v-juanli-msft Thank you so much for your response and for clearing my questions.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!