cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
say-t Frequent Visitor
Frequent Visitor

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.

ScreenShot.pngFilesizes

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Pbix File Size and txt file size

Hi @say-t 

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.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Pbix File Size and txt file size

Hi @say-t 

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.

say-t Frequent Visitor
Frequent Visitor

Re: Pbix File Size and txt file size

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