Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Is there any way I can add users to roles automatically? (e.g., through an API call)
@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