Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
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?
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.
How would I be doing that here? I am sorry, I am really new to RLS.
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.