Forum Discussion
RLS path
I am pretty new to RLS and have been trying to implement it in a certain way.
My table above is a sample. I am trying to create RLS here based on the levels. Normally I can create 3 roles for 3 levels where,
Level 1 is regular employees
Level 2 is supervisor of employees
Level 3 is the manager/head of the building (based on the BuildingID)
I am trying to create RLS where the manager (Level 3) will be able to see the data for people below them by filtering through. For example when the manager of BuildingID='233' logs in, they can filter through the report to see people they are assigned to.
It would be clickable in the filter pane. However, I am more used to on doing DAX calculations when the manager ID is on a different column and this seems to be a new scenario. I have tried a couple of methods and so far have not been successful. Any kind of help here would be much appreciated.
5 Replies
Is your sample table dominating the data model (does it sit at the outer fringe of the star/snowflake)? Have you defined the RLS rules for it?
Yes I have applied it. It works with the data model perfectly. I am just struggling to create hierarchy so that the manager can view the reports view of the employees below him.
I know how to create the path calculations when it has the manager ID in a seperate columns but unfortunately that is not the case here.
you do that by defining the rules for each role in the table. Doesn't matter if it's the same column.
