cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SLI
Helper III
Helper III

Adding users to role on power bi service automatically

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

 

 

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Thank you very much for your help 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!