Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RohanB
Frequent Visitor

Get details of Members/Users assigned to different Roles created for Row Level Security

Hi Experts,

 

I want to create a report for the Row Level Security Roles and the members/users assigned to those Roles.

 

Can we access the RLS Roles and Users data for a dataset?

 

Any guidance on the same will be very helpful.

 

Regards,

Rohan

3 REPLIES 3
v-robertq-msft
Community Support
Community Support

Hi, @RohanB 

According to your description, you want to get the detailed data of the RLS roles of a dataset, I think that creates the Dynamic Row-Level Security can help you achieve this. In this method, you can create tables which contain users and their UPN(Email name) related to the Role table, you can take a look and find out if it’s useful:

https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi

 

Best Regards,

Community Support Team _Robert Qin

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

Hi Robert,

 

Thanks for the guidance.

 

My scenario is if there is an existing static RLS setup for a dataset , can I get access to data for the RLS Roles and the User tagged to those role which we can see see from the Security option.

 

In tableau they maintain the metadata information in a postgre DB. Is there any such option in power bi to get the metadata information for the RLS roles and users tagged to those roles?

 

Regards,

Rohan 

Hi, @RohanB 

Unfortunately, I guess that the only way to access the RLS Roles and linked usernames of a Power BI dataset is going to the “Security” of the dataset.

Here are some links about RLS and username, you can take a look:

https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

 

Best Regards,

Community Support Team _Robert Qin

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.