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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors