Implementing Row level Security to hide sensitive data

[Shadaiv]

Hi all,

Would appreciate your help in this. 

We have a matrix where under the rows section we have below columns

City Name

Branch Name  

Employee Name

and under the Value Section We have

Total Leave

Sick Leave

Annual Leave

All the above fields are from a single flat table.

The requirement is out of 50 users 10 users should see the data for all the rows ( City Name , Branch Name,Employee Name)

but other 40 users should see data only for ( City Name , Branch Name). In other words, they should not see Data at Employee Name Level.

Please advise any easy way to implement this security.

[v-rzhou-msft]

Hi @Shadaiv 

You may refer to this video to learn how to create Row Level Security with hierarchies.

For reference:

Row Level Security With Hierarchies

Dynamic Row Level Security with Organizational Hierarchy Power BI

Best Regards,
Rico Zhou

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

[selimovd]

Hey @Shadaiv ,

you can create specific roles and map them to each user:

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

Also you could create a table with all the users and the access they have and then dynamically filter with the USERPRINCIPLENAME function:

Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship - RADACAD

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic