cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dvhez Regular Visitor
Regular Visitor

Size diference between Power BI and workbook with Power Query?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Size diference between Power BI and workbook with Power Query?

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Size diference between Power BI and workbook with Power Query?

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.