sharing report with all company and Row Level Security for each employee

[Ricardofaster]

Hi,

I have a report consisting on a unique table with all employees of my company. I would like to share the report with all of them BUT they only can see the info of one line. 

I created a Rol for RLS like this: [Email] = USERPRINCIPALNAME() and IT works but what I do not want is to include 1000 people (all my company) in this rol one by one.

IS there any way to include all employees in a rol at the same time?

Thanks for your help.

[nandukrishnavs · Accepted solution]

@Ricardofaster 

You could map the Security Groups or Distribution list to the role.

Reference: https://www.fourmoo.com/2020/04/01/power-bi-which-groups-can-be-used-to-set-permissions-in-power-bi/

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#add-members

[v-shex-msft · Accepted solution]

Hi @Ricardofaster,

I think nandukrishnavs's suggestion should help with your scenario.

If you confused to create a security group with all users, you can take a look at the following blog about use Powershell script to bulk add/remove users to a group from a CSV file. (you can export users list from your organization)

PowerShell: Bulk Add/Remove Users From Groups 

Regards,

Xiaoxin Sheng

[nandukrishnavs · Accepted solution]

@Ricardofaster 

You could map the Security Groups or Distribution list to the role.

Reference: https://www.fourmoo.com/2020/04/01/power-bi-which-groups-can-be-used-to-set-permissions-in-power-bi/

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#add-members