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.
Is it possible to make automated the rls and avoid adding member of role on power bi service
my client has 400 persons to add into the rls and he wants to be done automaticcally
we have used a dynamic rls in desktop by using the username function
thanks for your Help
sli
Solved! Go to Solution.
Hey @SLI ,
you can create an Azure Active Directory security group, add this group to the RLS role.
Then you can create a PowerShell script adding the users to this group
https://www.alitajran.com/add-users-to-group-powershell/#:~:text=%20Add%20users%20to%20group%20with%...
, you can automate the exceution of the script, meaning scanning if there are new users which are meeting certain requirements and if so add theses users to the security group.
Hopefully, this provides an idea on how to tackle your challenge.
Regards,
Tom
Hey @SLI ,
you can create an Azure Active Directory security group, add this group to the RLS role.
Then you can create a PowerShell script adding the users to this group
https://www.alitajran.com/add-users-to-group-powershell/#:~:text=%20Add%20users%20to%20group%20with%...
, you can automate the exceution of the script, meaning scanning if there are new users which are meeting certain requirements and if so add theses users to the security group.
Hopefully, this provides an idea on how to tackle your challenge.
Regards,
Tom
Thank you very much for your help
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.