Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Issue with Username() and userprinciplename()

Hi team,

 

I have an issue in getting the username() who logged into the report. It says something's wrong with one or more fields.  Kindly help me why this is not working.

 

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , There is something wrong with the formula, It seems like is it checking for the field in the table.

     

    I tested both on March -2021 and they are working fine.

     

    Can you share the formula?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak  Hi, thanks for the response.  I'm using a measure with below formula. 

      username = userprincipalname() 

       

      even username = username() gave the same error.

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        Anonymous , I actually tried the same. Hope you are creating it as a measure, not a column. The column will not work.

        If it is the measure. Save the work, close, and open the power bi file again. I faced a couple of uncommon issues with March 2021 and resolved them with stop-start.

         

        Still, it does not work, check the version - if it March 2021 then report an issue -https://community.powerbi.com/t5/Issues/idb-p/Issues