Adding users to role on power bi service automatically

[SLI]

Hi everyone

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

 

 

 

[TomMartens · Accepted 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

[SLI]

Thank you very much for your help