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.
Hello Anonymous
No, the fields are not in the list unfortunately. Please see the below screenprint. Also, the values are as they should, i.e. the departmentNumber is empty and employeeNumber is our HR system's record ID. Thus, this must be a configuration in the connector to not include these two fields, which feels very weird to me as the fields are quite important in the AD and AAD environments.