Row Level Security by Team

[psbuser18]

Is it possible to implement dynamic row level security on team so that if the user is logged in and are in 3 seperate teams they can see all of the data for those 3 teams?

I have a team and users entity which both have a unique index. I have merged these into the fact table and created a path with the two integers to see all the available combinations of team and user.

However when I use row level security USERNAME() in Dynamics CRM the data is filtered to show only the logged in users data rather than all the teams data that the user is part of.

Is this possible and is using the Path() function the best solution for row level security on teams?

[v-cherch-msft]

Hi @psbuser18 

If we use Dynamic RLS, we only need to create a table which contains different usernames and create relationships in Power BI Desktop.For further,please have a look at below articles.

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

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

For 3rd party Links:

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Regards,