Forum Discussion

primolee's avatar
primolee
Icon for Helper V rankHelper V
5 years ago

Add a column with current permission login user email

Hello everyone,

 

I am pulling excel/csv from Sharepoint workspace and using Power Query as ETL tool, and data of a query will be written into database.  I want to add a column of the current permission login user email from Data source settings into the query, therefore, after written into database, I know each row is created or modified by whom.

 

Is there a way of doing so?

 

Thank you so much!

 

Best regards,

David

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    primolee 
    As far as I know, it is not possible. Adding the current login user from the datasources as a column also doesn't make sense. You can only import an existing list of a username into Power Bi. BTW, the Username() and Userprincipalname also not possible to return the datasource username.

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.