Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using RLS for individual employees based on windows login

Hi there,   I have developed a PBI report showing employee's hours submitted on a Time Tracker application.  My aim is for employees to be able to access this report via a Power BI Online App and ...
Need Help
SteveCampbell's avatar
SteveCampbell
Memorable Member
6 years ago

There is a DAX function called:

USERPRINCIPALNAME()

 

This will return the email (UPN) current logged in user.

 

Check out UPN part of this article to see how to use them in RLS:

Using the username() or userprincipalname() DAX function

 

Or check this atricle:

https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/dax-query-language-for-power-bi-and-power-pivot/userprincipalname-show-user-name-and-use-it-in-rls-dax-power-pivot-power-bi/

 

 

Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!

Stay up to date on  
Read my blogs on  

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks SteveCampbell  i'm half-way there using the articles you shared:

 

  • I set up a role in Desktop for Username()
  • Then I published the dataset to Power BI Online

I don't know what to enter under Security in Power BI Online. I tried adding myself to the role, and testing as user and all the visualisations are blank. I'm stuck!

 

Thanks

Jemma