Forum Discussion

BradRose's avatar
BradRose
Helper I
9 years ago
Solved

Row Level security

Good Afternoon:   I am trying to use row level security with the ()username function.  I was able to create Measure for username I called it "Login" it returns the results as expected.  When I try ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi BradRose,

    Within Power BI Desktop, username() will return a user in the format of DOMAIN\User and userprincipalname() will return a user in the format of [email protected].

    Within the Power BI service, username() and userprincipalname() will both return the user's User Principal Name (UPN). This looks similar to an email address.


    As Matt has mentioned above, username() will return a user in different format within Power BI Desktop and Power BI service. So could you try using the formula below to see if it works?

    Login = SUBSTITUTE ( USERPRINCIPALNAME (), "@contoso.com", "" )

    In addition, here is a good article about Dynamic RLS in Power BI for your reference. :smileyhappy:

     

    Regards

MattAllington's avatar
MattAllington
Community Champion
9 years ago

What format is the LANID?  Is it an email address or domain\username.  Be careful as the behaviour on powerbi.com and power bi desktop is different. 

  • BradRose's avatar
    BradRose
    Helper I
    9 years ago

    Matt:

     

    LANID is a coulmn in our employee table is the just the username.  In my measure I have stipped out the domain to match the column in the employee table. 

     

    Here is my measure   

    Login = SUBSTITUTE(USERNAME(),"NESTLE\","")

     

    Brad

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi BradRose,

      Within Power BI Desktop, username() will return a user in the format of DOMAIN\User and userprincipalname() will return a user in the format of [email protected].

      Within the Power BI service, username() and userprincipalname() will both return the user's User Principal Name (UPN). This looks similar to an email address.


      As Matt has mentioned above, username() will return a user in different format within Power BI Desktop and Power BI service. So could you try using the formula below to see if it works?

      Login = SUBSTITUTE ( USERPRINCIPALNAME (), "@contoso.com", "" )

      In addition, here is a good article about Dynamic RLS in Power BI for your reference. :smileyhappy:

       

      Regards