Visuals filtering based on the username()

[Anonymous]

Hi Team,

I have two columns, EmpID and MgrID with RLS (role) created as EmpEmail = username() || MgrEmail = username().

This gives the rows where an email id is listed in EmpEmail or MgrEmail.

I have a single card visual where i would like to show the EmployeeName who logged in.

Due to the RLS settings, the sigle card is picking up names of Employee as well as his reportees as his email id can be found in MgrEmail.

So what is the best way to restrict this card visual to show only the user logged excluding his direct reportees.

[selimovd · Accepted solution]

Hello @Anonymous ,

why don't you create a measure that gives back the USERNAME() or USERPRINCIPLENAME()?

User = USERPRINCIPLENAME()

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi

[selimovd]

Hey @Anonymous ,

did it work with the measure?

I'm curious if you could solve this issue 🙂

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Anonymous]

I have another question which i posted here. If you can clarify me on that i would be very grateful..

https://community.powerbi.com/t5/Desktop/RLS-with-admin-access/m-p/1732743#M683215

[Anonymous]

@selimovd 

Hi Selimovd, Thanks for checking on this.  Yes your answer helped me. Thanks a lot.