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.