Forum Discussion

Frequent Visitor

5 years ago

Solved

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

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

Need Help

Tips and Tricks

Ehren
5 years ago
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-editor-and/td-p/721465

3 Replies

Ehren
Microsoft Employee
5 years ago
Hi sp1. Are you wanting the current Windows user, the user signed into PBIDesktop, or something else?
- sp1
  Frequent Visitor
  5 years ago
  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
    Microsoft Employee
    5 years ago
    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-editor-and/td-p/721465

Forum Discussion

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

3 Replies

Related content

user principal name (UPN) question

fabric-cli login as Service Principal

Row Level Security using User Principal Name (UPN)

pyodbc login timeout expired when connecting to Lakehouse SQL endpoint using Service Principal

Community Login