USERPRINCIPALNAME() returning wrong email id in Power BI service

[nandukrishnavs]

Hi All

I have created a simple measure and showing this measure in a card visual.

emailid = USERPRINCIPALNAME()

 I tried to change the user using Test as role from RLS window.

For some users, the card visual is showing the correct email id. Few users it is showing the wrong email id.

below is correct

below is wrong

Note: InternalControl is my email id.

I tried to check the same in Power BI desktop and it is working as expected. Is anyone know what is the issue?

CC: @Greg_Deckler  @parry2k @amitchandak 

[thebigwhite]

I am facing exactly the same issue. 25/08/2023 I think this is a general bug

[JensEggerath]

Hi @v-xicai , 

I have exactly this problem in one of my workspaces. It only happens if someone is or had been member, admin or contributor on the given workspace, which would exempt them from standard RLS. Then, even if I remove the user from the workspace completely (only leaving report+dataset+RLS viewer rights), my own UPN is shown instead of theirs when using "view as role".

In my case, when the users log in themselves, RLS just seems to work as expected. It's only a problem when simulating access for someone else. I guess it either caches or queries historic contributor/member/admin roles when determining the access rights.

Best regards,

Jens

[parry2k]

@nandukrishnavs not fully sure how you are testing it? Did your user logged in and get different UPN or you are getting wrong when using Test As Role.

[nandukrishnavs]

Hi @parry2k. 

Actually my user has reported RLS not working. To identify the root cause, created a simple measure and tested above scenario myself. I'm getting wrong UPN when using Test As Role.

I am assuming, this could be the reason why RLS was not working properly. 

[v-xicai]

Hi @nandukrishnavs ,

Have the issue been resolved? If Yes, could you please show us the solution to help others having the similar issue and accept it as the solution ? We will appreciate you so much.

You may refer to the article Row-Level Security (RLS) to manage roles,  please see the link Power BI Desktop Dynamic security cheat sheet, which described the detailed steps. Maybe it doesn't work, there are some tips to let it work and test it efficiently.

Best Regards,

Amy 

Community Support Team _ Amy

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