Link Exchange dat and Active Directory

[Markzolotoy]

I have user emails from Exchange data that has a user id. Is it possible to link that id to AD data to fine user's department?

Thanks

[v-stephen-msft]

Hi @Markzolotoy ,

About getting data from Microsoft Exchange, please kindly refer to

Power BI: Get Data from Exchange

You can connect to Active Directory from Power  BI Desktop following the instructions in this blog, load user table and computer table into Desktop.

In addition, here is similar thread about how get AD attributes in Power BI for your reference.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.