Row Level Security

[Jawed]

I have set up RLS based on department. Now, when I assign one user to two departments, they are not able to see any data and it shows an error. When I assign them to just one department, then it works fine. Is there any trick that I have missed?

[v-diye-msft · Accepted solution]

Hi @Jawed 

Using && would translate as you column must simultaneously have both the values such as  ‘A’ and 'B’ which is logically impossible for a single field to do. Please make sure you use the “||” rather than “&&” in the DAX expression. 

Such as : [Department] = "A" || [Department] = "B"

If the issue still exists, it’s preferred that share us more detailed error info. Thanks !

Best regards,

Dina Ye

[Jawed]

Thank you @v-diye-msft . Let me try it and get back to you.

[v-diye-msft]

Hi @Jawed 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,

Dina Ye