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.
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.
Solved! Go to Solution.
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
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
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
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
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.