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.
This values are not visible for e.g. domain users accounts.
I could see them with domain admin rights:
Hi @edepaz ,
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.
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.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
We had a great 2022 with a ton of feature releases to help you drive a data culture.