Row Level security

[BradRose]

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 and link the username measure to the ID it does not return any results.

[LANID] = [Login]

Any insights as to what I am doing wrong?  I have a feeling I missing a few steps

Brad

[MattAllington]

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]

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 · Accepted solution]

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. 

Regards