Solved: About file size when uploading to Power BI

KellyWang · ‎09-03-2023

Hello, we are an enterprise user and have some questions regarding "POWER BI."

We are using Power BI with two different data sources:

Source (1): Importing data from Excel. Source
(2): Importing data from SQL Server.

However, it seems that importing data from SQL Server results in larger Power BI files (pbix) compared to importing from Excel.

So, we would like to confirm if importing from SQL Server always leads to larger Power BI files?

Ritaf1983 · ‎09-03-2023

Hi @KellyWang

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/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Ritaf1983 · ‎09-03-2023

Hi @KellyWang

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/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile