Power BI Analyze in Excel based file sharing security.

2022-06-18T05:57:33.887+00:00

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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,863 questions
No comments
{count} votes