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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.