Forum Discussion
RLS - All users or nothing?
As you mentioned, you could create a role that doesn't apply any restrictions, effectively giving users in this role access to all the data. You can use a rule in the role with a formula that always returns TRUE, like TRUE(), which does not filter any data.
Im referring to this
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-request-access
When granting access you can specify the audience of the user a the same time as granting access.
What I haven't seen yet is if at the same time you ALSO specify the RLS role for the user as well. So I am wondering if this is a seperate step or not.
AmiraBedh I think I found an answer to my query. I think it requires a seperate step. Not ideal but useful to know for planning. Thanks for your help today! Best wishes!