Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 team's results. I've included the link to my sample PBI file.
I need help with two things:
Ideally i'd like to set this up to be dynamic so if a team captain changes throughout the year, the model will pick it up.
Thanks,
Shahab
Solved! Go to Solution.
found the solution online here:
https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security
Also 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
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.
found the solution online here:
https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security
Refer , if this can help
Do non-captains have access to the model? if so, do they only see their own stats?
yes, non-captains have access to the model as well but only to their own data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |