Using current Active Directory user as a parameter

[Anonymous]

Hi, I am trying to use the name of the current Active Directory logged user as a parameter in Power Query, because I need to include it as a filter for another query, but I can't find a way. I have searched for a possible solution in this forum, but I haven't found anything related. Is there any way of doing that? Thanks in advance!

[v-kelly-msft]

Hi  @Anonymous ,

Try the graph API: https://msdn.microsoft.com/en-us/library/azure/ad/graph/api/api-catalog

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Jimmy801 · Accepted solution]

Hello @Anonymous 

i was trying to analyse the information that is queried with the function ActiveDirectory.Domains and I didn't find any information of the current log on. Als the credential needed to access ActiveDirectory are anonymous and you can not query them. I think there is no way to do that in power query. However if you are using Excel you could write a Macro and get the Application.UserName or access Windows somehow to get the user. I don't know if this would be a solution for you. 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy