Row Level Security - adding users to role automatically

[EmaF]

Is there any way I can add users to roles automatically? (e.g., through an API call)

[Anonymous]

@EmaF ,

Could you please share more information related to your requirement to help us analysis? You want to add user to role on PowerBI desktop or on PowerBI Service? How do you manage these users originally?

Generally, we can setup Dynamic RLS on PowerBI DeskTop, this method uses UserName() to recognize the current user, then it will use the security filter based on the username to other data, for more information, please refer to the following blogs:

http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
https://community.powerbi.com/t5/Community-Blog/Power-BI-Dynamic-Row-Level-Security-Tips-to-get-it-w...

For Power BI Service, we can firstly create a security group or distribution list in Office 365 to cover these users, then add the security group or distribution list as role member.


Regards,
Lydia