Dynamic RLS

[Anonymous]

Hi everyone,

I want to create dynamic row-level security. In my data table, I have 50 different employees divided into 10 teams. Each team has a team leader which can be seen in the job_title column. The report is only for the team leaders so they should only see data for their own team.

The data table contains name, team, job_title, and email

Can someone help me with this?

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could use USERNAME()/USERPRINCIPALNAME() function to implement dynamic row level security as described in the following similar blog.

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

[d_gosbell]

Reza over at Radacad.com has a number of articles on dynamic RLS. You could start by reading this one https://radacad.com/dynamic-row-level-security-in-power-bi-with-organizational-hierarchy-and-multipl...

[amitchandak]

Refer :https://community.powerbi.com/t5/Desktop/RLS-at-the-Team-Level-Data-Model-and-DAX/m-p/911797/highlig...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[Anonymous]

Hi @amitchandak 

It doesn't really make sense for me. Can you explain what I should do?