Connect Power BI to Active Directory

[A7mad]

Hi All, 

I want get user information from our active directory, the fields are (company, department, division, manager). I found below URL 

https://golive.anywhere365.io/platform_elements/powerbi_integration/additionalconfiguration/power_bi...

 I am able to get the data correctly, but I am facing an issue with "Manager" field is not showing correct data 

[v-eqin-msft]

Hi @A7mad ,

Did @AlexisOlson 's suggestion solve your issue? If so, please consider Accept it as the solution to help the other members find it more quickly. If not, please click the error field to show us the error message in detail.

Best Regards,
Eyelyn Qin

[AlexisOlson]

I think you might need to expand the manager column before doing the Group By.

When I tried this, [organizationalPerson.manager] column had Record values.