Forum Discussion
stuart_graham
4 years agoNew Member
active directory User Manager
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 ...
lbendlin
3 years agoSuper User
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
3 years agoAdvocate I
Perfect - thank you! 😀