Exchange Connection for Custom Contact Forms

AdrianC · ‎03-27-2017

Hi,

When I use the PowerBI exchange data connector to connect to an exchange address book, it only pulls through the contacts that are saved with the standard contacts form (IPM.Contact) despite there also being other contacts with a custom form there too. Does anyone know how to access the data saved in Outlook Custom Forms. e.g. contact information saved in IPM.Contact.UserForm?

Also, it does anyone know have to access other fields in an address book such as "Modified (Date)"?

Thanks,

A

Anonymous · ‎03-29-2017

Hi @AdrianC,

Use the Active Directory connector instead of Exchange connector in Power BI Desktop following the instructions in the blogs below , then check if you get all contacts and desired fields.

http://datapigtechnologies.com/blog/index.php/pull-your-global-address-book-into-excel/
https://matt40k.uk/2016/11/dangers-of-distribution-lists/

Thanks,
Lydia Zhang