Power BI Analyze in Excel based file sharing security.

Question

Hello evryone.

I have confidential information on Power BI reports.

I was give a challenge at my organization to create excel fles based on pivot tables that comes from the Analyze in Excel Power BI tool. I am the administrator of the workspace.

So I've opened my report app, created an analyze in excel pivot table based sheet and saved it.

Everything is good until I realize that if I send this xlsx file to a person that doesn't even have a free Power BI license, this person can open the file and refresh it sucessfuly.

I really need some help on how can I make the security of sharing an analyze in excel pivot table based sheets files better.

Obs: Every attempt to alter the connection configurations of the excel file fails once it reverts back to the previous configutations as soon as I refresh the pivot table again.