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 @Gdps
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 @Gdps
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
27 | |
23 | |
22 | |
16 | |
7 |
User | Count |
---|---|
33 | |
25 | |
18 | |
15 | |
13 |