Forum Discussion

clem2205's avatar
clem2205
New Member
1 year ago

Extract RLS members and views granted

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

  • clem2205  please review each solution and either click [accept solution] and the thumbs up button or provide more details, thank you ğŸ˜€