active directory User Manager

[stuart_graham]

Greetings Power BI dudes

I am trying to build my first report using live data from Active Directory.

I am trying to create a report that maps "displayName" to "manger" when I expand the data it show that user have managers with the word Record and if I repeat the process, I get a similar result, think is is show their Managers Manager.

I can get lots of other information but not the Managers name

If I keep expanding the colum I eventually get to point where it looks to of worked but I loss lots the data, but still just get Record in the colum.

This could well be the simples thing that I do not know 🤞

Thanks in advance

Stuart

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. Do  you want to build a company hierarchy or do you only need the name of the immediate manager?

[gthill]

I am trying to achieve this - I am looking to get the displayName of the immediate Manager - I expand the record of the organizationalPerson.manager, but it keeps coming back as Record.

What I am looking to get is a table with:

• User displayName
• User email
• User's Manager displayName
• User's Manager email

Thanks!

Gareth

[lbendlin]

I don't know how your AD is structured but in ours it goes something like this

let
    Source = ActiveDirectory.Domains("domain.net"),
    domain.net = Source{[Domain="domain.net"]}[#"Object Categories"],
    organizationalPerson1 = domain.net{[Category="organizationalPerson"]}[Objects],
    #"Removed Other Columns" = Table.SelectColumns(organizationalPerson1,{"organizationalPerson", "distinguishedName"}),
    #"Expanded organizationalPerson" = Table.ExpandRecordColumn(#"Removed Other Columns", "organizationalPerson", {"mail", "manager"}, {"organizationalPerson.mail", "organizationalPerson.manager"}),
    #"Expanded organizationalPerson.manager" = Table.ExpandRecordColumn(#"Expanded organizationalPerson", "organizationalPerson.manager", {"mail"}, {"organizationalPerson.manager.mail"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded organizationalPerson.manager", each [organizationalPerson.manager.mail] <> null)
in
    #"Filtered Rows"

[gthill]

Perfect - thank you! 😀