Forum Discussion

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

USERPRINCIPALNAME() returning wrong email id in Power BI service

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 

 

 

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      nandukrishnavs
      Icon for Community Champion rankCommunity Champion
      6 years ago

      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's avatar
        v-xicai
        Icon for Community Support rankCommunity Support
        6 years ago

        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.

  • JensEggerath's avatar
    JensEggerath
    Regular Visitor
    4 years ago

    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

  • thebigwhite's avatar
    thebigwhite
    Icon for Helper II rankHelper II
    3 years ago

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