Query Active Directory for extended attributes

[Anonymous]

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.

[PeRich]

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

[v-frfei-msft]

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]

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]

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

[Anonymous]

Sorry, I couldn't find any solution.

[gsav]

hello , 2 years after does anyone knows how to get these AD Extended attributes, I can't find them in any table

thanks

[gsav]

got it ! extensionAttributeXX are in table msExchCustomAttributes