Forum Discussion

JLaine's avatar
JLaine
Helper I
4 years ago
Solved

Import Global Address List?

Hello Power BI people ! As an inexperienced Power BI user, I can't seem to figure this one out so....   How can I import our company's Global Address List (as seen in Outlook and other Office apps...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    In this M code, replace "CompanyDomain.com" with whatever your domain is, in quotes, except for the Step Name CompanyDomain.com, which is without quotes, and the user step, which CompanyDomain.com is entered without quotes.

     

    let
    Source = ActiveDirectory.Domains("CompanyDomain.com"),
    CompanyDomain.com = Source{[Domain = "CompanyDomain.com"]}[Object Categories],
    user = CompanyDomain.com{[Category = "user"]}[Objects],
    #"Removed Other Columns" = Table.SelectColumns(user, {"displayName", "user", "organizationalPerson"}),
    #"Expanded organizationalPerson" = Table.ExpandRecordColumn(#"Removed Other Columns", "organizationalPerson", {"department"}, {"department"}),
    #"Expanded user 1" = Table.ExpandRecordColumn(#"Expanded organizationalPerson", "user", {"mail"}, {"mail"})
    in
    #"Expanded user 1"

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
4 years ago

You can use the Active Directory connector  to query the Organizational Person records.

 

--Nate

JLaine's avatar
JLaine
Helper I
4 years ago

Anonymous  Thank you.  When I slect "active Directory Connector" in the list of data sources, I see a lot of data tables, but I doo not see 'address book'.  I doo see 'addressBookContainer' but it is an empty table.  What table would contian the address book as seen in Outlook?