RLS using an Approver Email Column

[kayakingaway]

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 could only see the data in which they are the "Approver Email". I don't want to have to enter each person and their respective email. 

I tried the following..I have a very similar "Filter" on a Power App that works swimmingly, but getting some errors here. 

[Approver Email] = User().Email

Any suggestions? Tips? Helpful videos? 

I appreciate the help!!

[v-jingzhang · Accepted solution]

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.