Solved: Re: Dynamic RLS query

rwcampbell · ‎09-14-2021

Hi

I have a manager that wants to see their bosses account on their login as well as their team below them and vice versa.

Is there an option to do this?

amitchandak · ‎09-14-2021

@rwcampbell , In RLS you can see what is below you. On desktop, you can see what any user can see. Also, RLS does not apply to a workspace admin.

Of you need to create custom hierarchy where he is above his bosses

refer if needed

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎09-14-2021

@rwcampbell , In RLS you can see what is below you. On desktop, you can see what any user can see. Also, RLS does not apply to a workspace admin.

Of you need to create custom hierarchy where he is above his bosses

refer if needed

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Dynamic RLS query

Helpful resources

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - January 2025

Fabric Community Update - January 2025

How to Get Your Question Answered Quickly

New Offer! Become a Certified Fabric Data Engineer