Forum Discussion
Use Exchange distribution list as data source
Anonymous,
Can you access your import your Distribution Lists via Active Directory rather than Exchange - e.g. https://matt40k.uk/2016/11/dangers-of-distribution-lists/
Hi Anonymous,
Which items do you import from your Exchange account to Power BI Desktop? Could you please post a screenshot?
Based on my test, when I connect to my mailbox using Microsoft Exchange connector in Power BI Desktop, I can load these items (Mail, Calendar, People, Tasks and Meeting Requests) to Power BI Desktop. For the People table in Query editor, I note that Power BI Desktop retrieves data from Suggested Contacts folder in Exchange. There is an example for your reference.
When you expand the EmailAddress column, you can see the detailed email addresses of your contacts in your mailbox.
And you can get email addresses of recipients in Mail table.
Thanks,
Lydia Zhang
Anonymous,
Can you access your import your Distribution Lists via Active Directory rather than Exchange - e.g. https://matt40k.uk/2016/11/dangers-of-distribution-lists/
Anonymous thanks for the pointer the "group" container in Active Directory was able to get me the list of members in the distribution list. Thanks for the help.
If it helps others I needed to expand out the group.member list by converted it to a table and ended up wiht 700+ columns for each member of the distribution list.