Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
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