Forum Discussion

Jawed's avatar
Jawed
Helper III
7 years ago
Solved

Row Level Security

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 work...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    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

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

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's avatar
Jawed
Helper III
7 years ago

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

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    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