Forum Discussion

kayakingaway's avatar
kayakingaway
Frequent Visitor
3 years ago
Solved

RLS using an Approver Email Column

Hello All!    I have used RLS at a very base level but I am trying to do a step up.    I have a column within my table called "Approver Email", I would like to apply the RLS so the current user c...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi kayakingaway 

 

What you want is the dynamic RLS in Power BI. You can use userprincipalname(), which always returns the user in the format of their user principal name, [email protected].

 

[Approver Email] = userprincipalname()

 

Here are some blogs for your reference:

How to Setup Static and Dynamic Row Level Security (RLS) in Power BI?

Dynamic Row Level Security in Power BI (pragmaticworks.com)

Dynamic Row Level Security with Power BI Made Simple - RADACAD

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.