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.
Hello everyone,
I would like to ask your help to tell me what would be the best practice for creating an RLS for my report.
My situation:
I have a premium workspace with 60 people in Microsoft Teams, and I want to share a report with those 60 people. The report is about hours of work recorded in a sharepoint list.
However, I need to have 3 types of visualization:
Note: the manager needs to see his own information, in addition to their team information
I managed to create the RLS using an excel database with the following columns:
Resource Name | Resource E-Mail | Manager Name | Manager E-Mail |
But I found exhausting add 48 emails manually in the Security tab of the bi power service.
Is there a more practical way to do this? And to share this report, do I also need to manually add the 60 emails?
Best Regards,
Solved! Go to Solution.
Hi @Anonymous
I believe you can refer to the dynamical hierarchy RLS:
https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
do I also need to manually add the 60 emails?
No, when you manage them in the DAX formula, you can create a distribution list/Security group including their emails, and add the group directly in service.
Hi @Anonymous
I believe you can refer to the dynamical hierarchy RLS:
https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
do I also need to manually add the 60 emails?
No, when you manage them in the DAX formula, you can create a distribution list/Security group including their emails, and add the group directly in service.
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.