Project managers to only see their projects

[Anonymous]

Hi,

Sorry for my rookie question.

I have approximately 100 project managers in my organisation. They are all registered in the O365 of the organisation.

If my first name is Gold and my last name Whisky my email adress would be gold.whisky@nameofmyorganisation.com  the username in O365 would be Gold Whisky.

I have a table with the names of all project managers, their names(in the column "Project Manager") are listed like this (all caps) : GOLD WHISKY.

My goal is that Gold Whisky only sees his projects, so the one with the name GOLD WHISKY in the column "Project Manager", without having to create a role for every project managers.

I tested [Project Manager] = USERPRINCIPALNAME() and it's not working.

I tested the same but changing the column Project Manager to lower case and it is not working.

Do you have any ideas ? How can i link o365 usernames and emails to power bi

Thanks you in advance

[Anonymous]

Hi, thanks guys for your answer, userprincipalname worked, we just had to associate emails to names by creatinmg a relation.

Thanks again for your advices !

[amitchandak]

@Anonymous , have check what USERPRINCIPALNAME() is returning and take the action

Also refer:https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

[Greg_Deckler]

@Anonymous - Sounds like you are doing things correctly assuming your Project Manager column is their email address and this table has a relationship with your fact table. Try creating a measure that is simply: Measure = USERPRINCIPALNAME() and put that in a Card visualization to see what it is returning.

This may help: Dynamic Hierarchical Row Level Security (powerbi.com)