topic Re: Dynamic Row-Level Security - Members list in Developer

Dynamic Row-Level Security - Members list

Anonymous — Fri, 08 May 2020 21:46:42 GMT

I would like to know if there is an API that I can call to get the list of all members under the Row-Level Security group just like the one to get group users 'https://api.powerbi.com/v1.0/myorg/groups/{groupId}/users' that returns a list of users that have access to specific workspace.

In the attached screen below, I would like to return 42 members in the 'Salesrep' group.

Thank you,

Re: Dynamic Row-Level Security - Members list

nandukrishnavs — Sat, 09 May 2020 02:51:52 GMT

@Anonymous

I assume you are trying to reuse the member list of Salesrep. If that is the case, I would recommend you create an AD security group and apply that in the Salesrep role.

Also please refer to this link for understanding the various implementations of Dynamic RLS.

https://community.powerbi.com/t5/Service/Dynamic-Row-Level-Security-Single-Role-for-all-the-User/m-p/643064#M64083

https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/bc-p/808090

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

Re: Dynamic Row-Level Security - Members list

Anonymous — Mon, 11 May 2020 16:42:46 GMT

Thank you for your suggestion. I already created the AD security group and was able to get the members.