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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
mike00
Frequent Visitor

Hierarchical RLS not working

Hello Experts, 
I have sementic model on which I have applied dynamic RLS and Hierarchical RLS and published to workspace A. The logic is woking fine in power bi desktop. But it is not working in power bi service. I have added users in security and also given direct access of underlying dataset. When I test role of managers they can access all saslespersons data. Below is the screenshot.

mike00_0-1712642205845.png

But when I test role of individual person it not showing any data.

mike00_1-1712642387347.png
Below is the hierarchy

mike00_2-1712643657234.png

 


Below is the Excel and PBIX file link
https://drive.google.com/drive/folders/1jETIg-SbLmMhxodufeJ6ZbSXlOOaABxq?usp=sharing

I would greatly appreciate any guidance on resolving this issue. Thank you for taking the time to help.

 

1 REPLY 1
Anonymous
Not applicable

Hi, @mike00 

So far very little is known about Hierarchical rLS, need to learn about it to solve your problem, if there is any progress I will update here or someone else can help.

Best Regards,
Yang
Community Support Team

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors