Forum Discussion
RLS Super User or not
GryPTonite , not very clear. You have created a hierarchy or user access table
RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi
I guess the SuperUsers table is a custom list and acts as access table or rather a list of users that can see all timesheets. Person logged in is either a super user or not.
If a super user logs in he can see everyone's timesheets including his own, in order to diferentiate what is the super user's timesheets and those that are not I want a true/false flag per Timesheetlines (if the flag has to sit in the Timesheets table that is fine because I have a relationship via TimesheetId so I can use the RELATED function. What determines his own timesheet is his parent table Timesheets has a TimesheetOwnerId field that matches the ResourceId in the Resources table and this table has an emailaddress that matches the USERPRINCIPAL(). I suggest you read the link I provided to get a similar example, one person replied to this article suggesting it might be a bug and gave and alternative solution, is the alternative solution viable.
Hi GryPTonite ,
You may set Row-Level Security (RLS) to manage roles, please see the link Power BI Desktop Dynamic security cheat sheet, which described the detailed steps. Maybe it doesn't work, there are some tips to let it work and test it efficiently.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
