Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Query Active Directory for extended attributes

I have managed to query active directory succesfully but cannot find extended attributes (extensionAttribute1,extensionAttribute2,etc) anywhere, ¿which table contains those attributes?.

 

Thanks in advance.

Need Help

7 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi Anonymous ,


    We can connect to Active Directory from Power  BI Desktop following the instructions in this blog, load user table and computer table into Desktop.

    As per this similar blog and similar thread, user account status and computer status are controlled by the userAccountControl attribute, you should be able to expand userAccountControl column from user table and computer table in Power BI Desktop, then check the values.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you but I have connected with Active Directory without any problem, my issue is I cannot find the way to include the extended attributes (extensionAttribute1,extensionAttribute2,...) in a query.

      • wwhittenton's avatar
        wwhittenton
        Helper II
        6 years ago

        AnonymousDid you find a solution to this problem? I'm struggling with the same thing.

  • PeRich's avatar
    PeRich
    Regular Visitor
    5 years ago

    This values are not visible for e.g. domain users accounts.

     

    I could see them with domain admin rights:

    1. Logged on to Windows as domain admin,
    2. started Power BI Desktop, 
    3. opened Active Directory,
    4. selected "table" "user"
    5. msExchCustomAttributes.msExchExtensionCustomAttribute1 - n