Hi everyone,
I am a little bit confused about the following behavior in Power BI Desktop.
I imported data from a 114 MB CSV-File using Import-Mode (in other terms I am using the VertiPaq-Enginge) which ends up in a 355 MB large data model in memory in Power BI Desktop.
I expected VertiPaq-Compression to reduce the data in size or at least keep it in the same size like in the data source. Power BI takes up more space than the raw CSV. I'm wondering what coul be causing this increase.
Here are some more technical details:
I have a CSV-File as datasource which includes 10 Million rows of unique SalesOrderNumbers (see first image below).
Each row consists a 10 characters long SalesOrderNumber (meaning 10 Bytes Storage) plus a line break (additional 2 Bytes of Storage). So in total we have a 120.000.000 Byte of data plus a 16 Byte Column Header, resulting in 120.000.016 Byte large CSV-File which is round about 114 MB (see next image below).
After I imported this data into Power BI Desktop in a single One-Column-Table I saved my *.pbix-file, closed it and re-opened it (without any explicit refresh in PBI Desktop) and opened DAX Studio to do an investigation with VertiPaq-Analyzer.
The result shows that the total size of my "data model" is 355 MB in memory (see next two images)
My *.pbix-file has a total size of round about 111 MB (see very last image below).
Any insights would be greatly appreciated!
Thanks!
