RLS measures

[syasmin25]

Hello, 

I had a question, I have a users as level 1 in the RLS file. However, for email groups, the user is in both a level 1 email group as well as level 2 email group. When I only have the level 1 email group added in security and share it with level 1 email group, he can only see data for the building he is working for. However, whenever, I give access to the level 2 email group, that user starts getting access to everything. Is there a way around this? How would I resolve it?

[v-jingzhang]

Hi @syasmin25 

If a user is a member of multiple RLS roles, he will have the highest access right among these roles. If you want RLS roles with Hierarchy, please refer to these links:

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-...

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-...

Regards,
Community Support Team _ Jing Zhang