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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
BenBrubacher
Frequent Visitor

Dynamic Row Level Security without having to add to Security Group

I have a question about dynamic row level security.  I want employees to only be able to see their own results.

I created a role in Power BI Desktop called "Agent" with a rule/filter  [Agent] = USERPRINCIPALNAME() . 

 

Currently i have to add each agent to the "Agent" role in the power bi Service.  

 

The problem I am trying to solve for, with this specific report only, I simply want the rule to apply automatically without having to add the user into the role in the security tab in power BI Service. 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @BenBrubacher ,

 

You can use Dynamic Row Level Security for individuals or groups. But the best suggestion is to add users to the security group, because report developer will only have to implement DRLS Once.

 

For details, please refer to related links:

Dynamic Row Level Security is easy with Active Directory Security Groups - Reporting/Analytics Made ...

Can you use GROUPS with Power BI Row-Level Security (RLS)??? - YouTube

Dynamic Row Level Security with Power BI Made Simple - RADACAD


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

 

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

View solution in original post

1 REPLY 1
v-henryk-mstf
Community Support
Community Support

Hi @BenBrubacher ,

 

You can use Dynamic Row Level Security for individuals or groups. But the best suggestion is to add users to the security group, because report developer will only have to implement DRLS Once.

 

For details, please refer to related links:

Dynamic Row Level Security is easy with Active Directory Security Groups - Reporting/Analytics Made ...

Can you use GROUPS with Power BI Row-Level Security (RLS)??? - YouTube

Dynamic Row Level Security with Power BI Made Simple - RADACAD


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

 

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 PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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