Power Query - Query Active Directory for User's Manager

I'm new to Power Query and I'm trying to create a query that returns user information from our Active Directory that displays the User's DisplayName and Manager.

I can drill into the user column and see the Manager, but when I just select the Manager from drop down of the User. It returns a Record Link and when I click on it drills into the User's Manager Detail.

Here are the steps I'm taking to filter to the User.Manager

PowerQueryScreenShot
thomas-sherrouseAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

regmigrantCommented:
Don't have access to AD data structure at the moment but as no-one else has offered a solution:-

In database terms you are already retrieving the foreign key to the manager record, you need to join the staff table to itself so that the query can recursively find the display name for the manager.

In sql this would be along the lines of

select emp.displayname, mgr.displayname from Employee Emp, Employee MGR
Where emp.Manager = mgr.ID

Open in new window

thomas-sherrouseAuthor Commented:
regmigrant - thanks for your help. I think I've figured it out. I'm not sure how to explain the solution. Thanks again.
thomas-sherrouseAuthor Commented:
I was able to figure it out by selecting the drop down menu from the drill down option and select the field I needed.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
regmigrantCommented:
glad to hear, please close as you think appropriate
thomas-sherrouseAuthor Commented:
I don't think I could explain my question clearly. I was able to figure out my question.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.