Forum Discussion

dirkmuis's avatar
dirkmuis
Helper II
7 years ago

UPN function not working correctly

If I'm user the USERPRINCIPALNAME() on a gmail account I do get the msn.com# returned which should be part of the USERNAME() function. Is this a known issue or is the function broken?

With another domain (outside organisation) the UPN() works perfect.

Need Help

9 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    Hi there

    I have found that even though that is displayed from the picker, if you are using RLS it will still use the actual email address
    • dirkmuis's avatar
      dirkmuis
      Helper II
      7 years ago

      I tried with an @gmail.com and with an @somethingelse.com.

      The @somethingelse.com does return the e-mail adress. 

      The @gmail.com does return the UN() so e.g. msn.com#[email protected]. I've no idea where the MSN part is coming from? That must be because the gmail has been registered at microsoft for using with powerBI.

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        dirkmuis ,

         

        Yes, the external email account will be changed temporarily. You can ignore them when you build dynamic RLS, creating a column using original gmail can work well.

         

        Community Support Team _ Jimmy Tao

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