Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 @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.
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.
@AnonymousDid you find a solution to this problem? I'm struggling with the same thing.
Sorry, I couldn't find any solution.
hello , 2 years after does anyone knows how to get these AD Extended attributes, I can't find them in any table
thanks
got it ! extensionAttributeXX are in table msExchCustomAttributes
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.