Row Level Security

Hey Anonymous ,

as soon as you apply Row Level Security each user has to be assigned to a Role. For this reason it is necessary that you create an additional role and call it "No restrictions" or something similar. For consistency I select the same table and column I used for the other roles. The I use the below DAX statement (even if it does not look like one):

1 = 1

It's most simple statement I can think of that evaluates to true.

As the DAX statement that will be evaluated to determine if access is granted to a specific row has to return true, and the above statement is always true, basically no restrictions will be applied to users that have be assigned to this role.

Be aware that you can also assign Security Groups to RLS roles, this can spare you a lot of effort instead of assigning 100s of internal users to the "No restrictions" role.

Hopefully, this provides what you are looking for.

Regards,

Tom