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 a master data table and a user group dimension table. And they are joint together in the data model. The use case is, I want to give certain viewer only partial data visiablity to a specific group(usergroup). I was trying to do so by applying RLS (row level security).
For example, I created a role where group(aka. usergroup, a column in user group dimension table) = "Technical Team".
Then I tested this role by 'View As' function. You can see from the screenshot, the drop down content of group(usergroup) slicer is indeed being limited to "Technical Team". However, the data didn't actually change or say being limited until I clicked on "Technical Team". For some reason, this Role is working superficially, not restricting the data in an automated way.
The filtering of the data in a role flows along the relationships in your model. So if the role is not working as you expect it could be because there is an issue with the way your relationships are setup. What is the relationship between the group table and whatever fact table you are looking at?
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 |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
11 | |
5 | |
5 | |
3 |