How to get login user name/user principal name in Power Query

[sp1]

Hello,

I want to retrive the login username/userprincipalname in Power BI desktop using power query. I am unable to use system's username/userprincipalname function because they are not work on calculated Tables/Columns so I am trying to get the username/userprincipalname from power query.

Can you please help me for that?

Thank you 

[Ehren]

Hi sp1. Are you wanting the current Windows user, the user signed into PBIDesktop, or something else?

[sp1]

Hi @Ehren ,

thank you for your response.

I am trying to embed the Power BI report on Portal. So when the user login on portal then I want  that user's userprincipal name to filter out the data.

[Ehren · Accepted solution]

Have you tried any of the suggestions found in this thread?

https://community.powerbi.com/t5/Power-Query/Can-we-retrieve-logged-in-user-name-in-Power-BI-Query-e...