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.
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.
AmiraBedh Thanks for the reply!
How does this work with the PBI Request email?
When granting access do you have to specify a role as well as an audience (as part the process) or do you have to grant access to the audience then assign the role seperately (as an extra step outside of the process)?Now I am a little bit lost. How ware you configuring your RLS ?
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.
