Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
pennyfan1031
Regular Visitor

Data is not restricted after applying RLS

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).  

pennyfan1031_1-1623360038061.png

 

For example, I created a role where group(aka. usergroup, a column in user group dimension table) = "Technical Team". 

pennyfan1031_0-1623359659507.png

 

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.

Screen Shot 2021-06-10 at 4.43.53 PM.png

1 REPLY 1
d_gosbell
Super User
Super User

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?

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.