Forum Discussion
RLS upside-down
Assuming you have an existing RLS role that is working the way you want and all you need to do is to give one of your users access to all the data. Then all you would need to do is to create a second role in your model with no restrictions or filters then add the user to this role. The permissions in roles are unioned together so this should grant unlimited access even if the user is also in the RLS role.
Hi Maria_Maria ,
Please correct me if I have misunderstood.
You are now expecting one person in this organization to see all the content you want him to see all the time, while other users can only see limited content.
As a simple example, let's say you want to complete a manager-level RLS where your manager role users can see all the data all the time, and the people managed by the manager can only see the parts you want them to see, even if they are new to the organization and follow this rule.
If this is what you want, you can refer to this article below to set up an RLS.
Dynamic Row Level Security with Manager Level Access in Power BI
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.