Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |