Import Exchange distribution groups into power bi

[jetboy2k]

Is there a way to import the member list of a distribution group in Exchange into a table in PowerBI. I''m able to connect using the Exchange Connector, but all I can see are the following:

I've added the DG that I want to see the members of to my Contacts list, but when I click on the People checkbox above, I get an empty table:

Can this be done using Power BI and the Exchange connector?

Thanks.

[Anonymous]

@jetboy2k,

Please use Active Directory connector instead of Exchange connector in Power BI Desktop to import member list of your distribution group. There is also a similar blog for you reference.

https://matt40k.uk/2016/11/dangers-of-distribution-lists/

Regards,