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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sp260
Frequent Visitor

Apply RLS on horizontal level

Hello everyone,

 

Here is an example of data i am working with :

Fact table 

sp260_1-1685019269356.png

Managers table

sp260_2-1685019289595.png

 

And here is the role that i've created  for test : 

sp260_3-1685019369818.png

 

I am working on a business need who requires that a manager could see the global amount of his collegues but not the details.

Initial report looks like that :

sp260_4-1685019439974.png

Below the result when i apply my role : 

sp260_5-1685019517867.png

But what i really need is this : 

sp260_7-1685020353372.png

A picture is worth a thousand words : the manager (M1) have to access only the data of his station (G11) or the global amounts of his hierarchy.

sp260_6-1685020153506.png

 

Do you have any idea how could i achieve this ? I would greatly appreciate any insights or help.

 

Kind regards,

 

3 REPLIES 3
lbendlin
Super User
Super User

I don't think you can use static RLS for that.  Consider using dynamic RLS.

Any idea how to do this with dynamic RLS ?

It's as simple as maintaining a permissions mapping table that you control via USERPRINCIPALNAME.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors