Forum Discussion
Use Exchange distribution list as data source
Is it possible to access exchange distribution lists (on Global address list) as data sources in PowerBI and if so whats the best way of doing so? I would like to be able to take the members of a di...
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,
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.