File Size Difference with Different Data Source Type

[loujiang]

Hello, 

I have same data in two kind of source: one Synapse Analytics with SQL View and one in Azure Storage with .csv file. 

I use the same logic to process the data and the outcome is quite the same.

However, the File Size of the PowerBI file are different. The .csv file source only takes up 18 MB and the SQL View file uses 30MB space. 

I am comfused about it, since the data content is the same, why it could make so much difference. 

Thanks for helping. 

Best wishes

[loujiang]

Thanks for the help. I use the tool metioned to have a close check on data. The data column is somehow duplicated and file size problem is solved. 

[jdbuchanan71 · Accepted solution]

@loujiang 

You could use the Vertipaq Analyzer and hook it to each of the files.  It will show you the amount of space each of the columns and tables take up.  That might help identify where the difference is.

https://www.sqlbi.com/tools/vertipaq-analyzer/