Size diference between Power BI and workbook with Power Query?

[dvhez]

I have almost the same data and my .pbix file is 10 mb while .xlsx is about 200 mb. Why is that? If I share to someone this .pbix file, is he going to see everything?

[v-piga-msft · Accepted solution]

Hi @dvhez,

Do you mean that your pbix and your excel workbook have the different sizes with the same data source?

It may caused by the options you done for the different files. such as creating the Power Pivot in workbook.

Normally, if you share the pbix file, the receiver will see everything except for data source.

If the data source is enter data, then the receivers will see the data source.

Best Regards,

Cherry