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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
karpandi
Regular Visitor

RLS role with filter restricted access

Hi Team,

 

I have a report with many subteams. Managers shouldn't see eachothers result, but they should see their own and those above in the reporting line. (Each manager should see company overall result, parent division result and own result.)
How can I solve this with RLS?

 

Thanks and regards,
Andrea

3 REPLIES 3
v-deddai1-msft
Community Support
Community Support

Hi @karpandi ,

 

It cannot be achieved through rls. The purpose of RLS is to limit users to only see the data that they have permission to see. Your requirement goes against it.

 

I also recommend you create an idea for it  in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.

 

Best Regards,

Dedmon Dai

 

karpandi
Regular Visitor

Thank you for your reply. I was successful with setting up RLS with Organizational Hierarchy.

 

Unfortunately I couldn't find any solution for getting access to an overall result of the compnay or parent division without the possiblity of filtering (to other teams). Is there a solution for that?

GilbertQ
Super User
Super User

Hi @karpandi 

 

This can certainly be done.

 

Please look at this blog post by Reza Rad on how to achieve this: https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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