Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.