Hide sensitive information from people with edit permission

[a_gaisin]

Hello,

I'm trying to figure out how to work with sensitive information in Power BI. My data has a table containing personal information of the people (their salary). What I want to do is to create a report where only eligible people will see this data. I tried to implement it using RLS, and it works well in Power BI desktop, but doesn't work in app.powerbi.com, because it's necessary for all the users to have read-only access(viewer permission). I cannot do that, because users should be able to analyze my report in excel and refresh the data, which is impossible if they have viewer permission. 

Is there any way to hide sensitive data from non-eligible people, and at the same time let them to analyze report in excel and refresh data?

Thank you!

[v-lid-msft]

Hi @a_gaisin ,

Based on my test, if we did not give the user to edit the report, they can still use analysis in excel feature if we give them build permisson of dataset.

Based on this document: There are a few requirements for using Analyze in Excel: Users can connect to datasets through Analyze in Excel if they have permission for the underlying dataset.

It will block user to  refresh the data. But can make a automate flow to refresh dataset as a workaround, when user execute the flow, the the flow refresh teh dataset.

Please refer to this document: https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

But it actually 

[santabreeze]

Check this out, you can manage the data security on Power BI service.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls