implement dynamic row level security

Anonymous · ‎02-25-2019

hi,

I have a requirement for dynamc rls security.

In AD, we have a location attribute and based on loation the user should only see data for that particular location. This is simple but other thing is if user is an executive like manager, director and above he should see all locations data. How to put that condition on RLS?

Second thing is, if user is not associted with any location (location field is blank), he should see report but the report should show 'No Data'. How to implemnet this/

v-cherch-msft · ‎02-25-2019

Hi @Anonymous

You may have a look at below articles.

https://www.youtube.com/watch?v=9wN33rTaiB4

http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

https://community.powerbi.com/t5/Community-Blog/Power-BI-Dynamic-Row-Level-Security-Tips-to-get-it-working/ba-p/76865

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.