Extract RLS members and views granted

[clem2205]

Hi, 

I would like to extract a complete list of all RLS members with the views that they are granted in the report.

Any way to do that ?

Thanks a lot for your help!

BR,

Clem

[speedramps]

@clem2205  please review each solution and either click [accept solution] and the thumbs up button or provide more details, thank you 😀

[Anonymous]

Hi @clem2205 

Thank you very much speedramps for your prompt reply.

Go to the Power BI service and navigate to the dataset you want to extract RLS information for.

Under the Security tab, you can see the roles and the members assigned to each role. Unfortunately, there is no direct export option, so you may need to copy this information manually.

Alternatively, you can consider the following:

You can try implementing dynamic row-level security using Active Directory security groups to simplify the management of RLS roles and members. This way, you can manage users in AD groups and map those groups to roles in Power BI.

The following links may be helpful to you:

Solved: Extract RLS roles and users assigned - Microsoft Fabric Community

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[speedramps]

Learn how to view the RLS roles and how to Manage the security role memebrs here

https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security

Please click the [accept solution] and thumbs up buttons, thank you