Using RLS for individual employees based on windows login

[Anonymous]

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 only see their data. 

There are hundreds of employees so I cannot create an individual login for each.

When we come into work, we have a User ID and password which logs us into the network. 

I have User ID in my Time Tracker report, so I somehow need to reference who is logged in to that computer? 

Jemma

[SteveCampbell]

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-...

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]

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