Forum Discussion
sheidari
6 years agoFrequent Visitor
RLS at the Team Level: Data Model and DAX
I am looking to set up RLS for team captains identified for 68 teams in a league. Each team has 1 team captain and when that team captain logs into their dashboard, they should only see their entire...
- 6 years ago
found the solution online here:
https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security
amitchandak
Super User
6 years agoAlso refer, if this can help
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
sheidari
6 years agoFrequent Visitor
These are great for hierachy level RLS, but mine is just focused on team-level. If I am the team captain for team #3, I should be able to just see the transactions for team 3 (including all its players) and no other team.
- sheidari6 years agoFrequent Visitor
found the solution online here:
https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security