Access Manager field On-Premise Active Directory

[tilmant]

I have been working with Power Bi for a few weeks now building different reports, so I'm a novice. In my latest attempt to learn more, I have connect Power BI to our On-Premise Active Directory and selected the User view. I have expend section of the view and every things working except for the Manger field.

Since the manager field is a reference field, I'm not sure where to get the data in BI. When I expend and capture the field, the rows show the word "record".

Is there a way to put in a reference field such as manager?

[Anonymous · Accepted solution]

@tilmant,

Do you want to expand data from the Manager field? If so, click the button as shown in the following screenshot, and you will be able to get the data inside.


Regards,
Lydia

[tilmant]

Thank You.   I was expending the manager field, but it again showed me all the fields as when I expended users so I thought I had to select the manager field again.  So I was just looping.   After thinking through your response, I tried it again and selected display name instead of manager and sure enough, it displayed the managers name.  Again thank you.

[Anonymous]

@tilmant,

If you have solved this issue, please accept appropriate replies as answers to close this thread.

Regards,
Lydia