Forum Discussion
Retrieving employeeID and Department from Active Directory power query
Hello, In connecting with my Active Directory, I can get the User object. However, the attributes this object provides me is not really coherent with what's being used. For example, departmentNumber...
Hello Anonymous,
The record/object in which I could find employeeID and division was the organizationalPerson and not the user object. This is weird and I've communicated this to Microsoft's support.
Hi Anonymous ,
1. Could you find department and employeeID in User Record? Please search :
2.For example, departmentNumber and employeeNumber exist in the query, but not department and employeeID.
If the Name is not matched, how about the Values?
Refer to:
https://community.powerbi.com/t5/Power-Query/AD-attributes-in-Power-BI-report/td-p/84848
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.