filter data based on user email

[Anonymous]

I would like to show only the data related to the viewer email, from what I read around it should be feasable in Power BI, 

however I can't find a way.

I have already all the data in my data set, with 2 kind of users, employees and DMs, I would like to show different data (even in different pages) 

EMP CODE	EMP AREA	EMP EMAIL	DM EMAIL
123	AAA	EMP1@EMAIL.COM	DM1@EMAIL.COM
456	BBB	EMP2@EMAIL.COM	DM1@EMAIL.COM

EMP AREA connects this table to all my other data (1:many relationships)

Anyone could help?

Thanks in advance 

[Anonymous · Accepted solution]

Hi  @Anonymous ,

As @Greg_Deckler said, to verify that your configured rls is in effect, just select view as. The reference is below:

Best Regards,
Adamk Kong

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

[Greg_Deckler]

@Anonymous Yes, this is done by creating an RLS rule on the table and using USERPRINCIPALNAME such as:

[EMAIL] = USERPRINCIPALNAME()

[Anonymous]

Many thanks!

I've done the following and seems to work

But is there any way to test this? 

I've tried "View as" but whatever I select the data doesn't seem to be filtered 

[Greg_Deckler]

@Anonymous So when viewing as, you need to select the role and then "Other user" and type in the email address of the other user who you want to impersonate.