Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
syasmin25
Helper V
Helper V

RLS path

I am pretty new to RLS and have been trying to implement it in a certain way. 

 

syasmin25_1-1594906110547.png

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. 

 
 

tEmp.PNGIt 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 5
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.