Row level security based on fields from multiple tables

[shashankp1]

Hi ,

I wanted to apply row level security on fields from multiple tables as like below.

Employee[Dept]="Sales" and Location[City]="Paris"

Problem is that I can apply dax expression on single table only in power BI desktop.May I know how to create role based on fields from multiple tables.

Thanks,

[amitchandak]

@shashankp1 , refer these

row-level-security-patterns has explained few things pretty well
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/

[shashankp1]

Thanks Amit for providing links ,all are useful.Thanks.

[nandukrishnavs · Accepted solution]

@shashankp1 

Under single role, you can apply filter conditions for multiple tables, one by one.

Example click Employee table and apply the filter condition. [Dept]="Sales"

Then click Location table and apply the next filter condition. [City]="Paris"

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[shashankp1]

Thanks for the quick reply.

So this will create AND condition right.just for my info,what if I want to create "OR" condition.So any different approach.Once again Thanks.

[robindlc]

To create an "OR" condition I did by creating 2 different roles. In this case one role for

Employee table and apply the filter condition. [Dept]="Sales"

another role for Location table and apply the next filter condition. [City]="Paris"

An then asign the desired member to the 2 roles, so this member will see all "Sales" and all "Paris"