cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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 works fine. Is there any trick that I have missed?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Highlighted

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

Highlighted

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors