Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 thi...
Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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?