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...
Need Help
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Sorry, I couldn't find any solution.