Using RLS for individual employees based on windows login

Question

Hi there,&nbsp;I have developed a PBI report showing employee's hours submitted on a Time Tracker application.&nbsp;My aim is for employees to be able to access this report via a Power BI Online App and only see their data.&nbsp;There are hundreds of employees so I cannot create an individual login for each.&nbsp;When we come into work, we have a User ID and password which logs us into the network.&nbsp;&nbsp;I have User ID in my Time Tracker report, so I somehow need to reference who is logged in to that computer?&nbsp;&nbsp;Jemma

stevecampbell · Answer

There is a DAX function called:USERPRINCIPALNAME()&nbsp;This will return the email (UPN) current logged in user.&nbsp;Check out UPN part of&nbsp;this article to see how to use them in RLS:Using the username() or userprincipalname() DAX function&nbsp;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/&nbsp;&nbsp;Love hearing about Power BI tips, jobs and news?I love to share about these - connect with me!Stay up to date on&nbsp;&nbsp;Read my blogs on&nbsp;&nbsp;

anonymous · Answer

Thanks&nbsp;SteveCampbell&nbsp; i'm half-way there using the articles you shared:&nbsp;I set up a role in Desktop for Username()Then I published the dataset to Power BI OnlineI 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!&nbsp;ThanksJemma

Forum Discussion

Using RLS for individual employees based on windows login

2 Replies

Related content

Missing employee

Counting Active employees per month

Related employees via bridge

Headcount, Joiners, leavers and Mobility of employees.

window function