Using PowerBI for sensitive people data

[Gps-ma]

Hi 

Our HR department is interested in using PowerBI data for highly sensitive compensation data, however they are worried about people in data team being able to access this data. They dont even want admins to be able to access it.

Has anyone come across similar situation? How did you handle it?

I pointed out that admins always can access to data even files saved on sharepoint. They pointed out the thier files are password protected.

Its a fair challenge but not sure how powerBI would handle such situation.

[Anonymous · Accepted solution]

Hi, @Gps-ma 

Thanks for the reply from lbendlin, please allow me to provide addition:

You can use sensitivity labels, and Power BI integrates with Microsoft Purview Information Protection to allow you to apply sensitivity labels to your data. These tags help classify and protect data, ensuring that only authorized users can access it.

You can check the following links:

Sensitivity labels from Microsoft Purview Information Protection in Power BI - Power BI | Microsoft ...

You can also use row-level security (RLS), which is implemented to restrict row-level data access based on user roles. This means that users will only be able to see the data they are allowed to view. Object-level security (OLS) can also be used to restrict access to specific tables or columns in a dataset. This adds another layer of security by ensuring that sensitive columns are only accessible to authorized users. You can learn more from the following links:

Power BI Row-Level, Column-Level and Object-Level Security (mssqltips.com)

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

How to apply sensitivity labels in Power BI - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

The Ultimate Guide to Row-Level and Object-Level Security in Power BI | by Gunjan Sahu | Nerd For Te...