Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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.
But when I test role of individual person it not showing any data.
Below is the hierarchy
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.
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
| User | Count |
|---|---|
| 52 | |
| 44 | |
| 40 | |
| 15 | |
| 13 |