Re direct or automatic sign in using UPN for personalized dashboard to extract data from outlook.

[Anonymous]

Im creating a dashboard for detailed insights in meeting analytics using Outlook calender. As of now I have done dashboard which asks user to put email id as input parameter but instead of this I would like PowerBI to select/detect/capture email id automatically from UPN. So once user open power bi template, he/she should be able to see insights directly without even putting email ID.

[parry2k]

@Anonymous there is dax function called userprinciaplname, may be that can help

[Anonymous]

Hi Parry2k,

Thanks for replying. I want user principal name as a source in querry. I created parameter which asks for a input to user,so user email id becomes source in querry.

- So I want userprincipal name as source. 

-This is for the purpose of getting meeting insights only for people who are working in our company. 

- I short, I dont want user to put his email id as a data source, instead I want power bi to detect userprincipalname and extract data accordingly.

[parry2k]

@Anonymous the way i see it working is that you pull all the data with email in it and then you add a column in you model something like this

Current User = 
Table[Email] = USERPRINCIPALNAME()

and now you put a report level filter with "current user = true"

And other solution could be Dynamic RLS.

[Anonymous]

@parry2k It seems it creates table out of the power querry but instead I want to do it in the power querry.