Forum Discussion
Solved
RLS Query - Power BI
Hello Microsoft Community, I’m fairly new to Row-Level Security (RLS) and have successfully implemented RLS based on a hierarchy using a summary table that contains the hierarchy structure. So when ...
You can extend your existing rule with an OR condition for the users who should have full access.
PATHCONTAINS ( 'Employee Table (RLS)'[Path], USERPRINCIPALNAME() ) || USERPRINCIPALNAME() = "[email protected]"Or simply create a new role and add those people who will have full access withount bounding to the role with RLS.
Hello,
you can create a role in which you do not inject any filter, so just give it a name and you can assign this role to the manager through his e-mail
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI