Setting up RLS

[mattcornish]

Hi All

Not sure how to ask this, so i'll describe my desired outcome.

I have a dataset that has 2 Roles setup (Can See, and Can't See).

Can See is able to view a specific column in a table

Can't See, can't see it

I want the default behaviour of everybody to be in the Can't See role, so adding in a group that has everybody in it.

Then if they are added to the Can See role, that takes precedence over the Can't See role.

Is this default behaviour or would the most restrictive role apply

[Greg_Deckler]

@mattcornish That is the default behavior. Are you using OLS (Object Level Security) or are you doing something like this? Column Level Security - Microsoft Power BI Community