Pbix File Size and txt file size

[Anonymous]

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.

Filesizes

[Anonymous]

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 · Accepted solution]

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.

[Anonymous]

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