Outlook Group and Group member

[santh00]

Can we enter outlook Group Name and see list of group members in PowerBI Desktop

[Anonymous · Accepted solution]

Hi @santh00 ,

Can you access your import your Distribution Lists via Active Directory rather than Exchange - e.g. Da

Luckily, this is really easy in Excel 2016. Built into Excel 2016 is PowerQuery and one of the out-of-box connectors is Active Directory. With a bit of PowerQuery magic, you can easily pull this data out.

So we want to:

• Connect to our Active Directory
• List out all our Groups
• Filter to email-able Groups
• Include
  • the group owner
  • the members
  • any security \ restrictions on who can email the list

Note: If your unluckily enough to be running an old version of Excel, it possible to do the same thing in Power BI Desktop, which is a free download.

ngers of distribution lists | Matt40k

•  

I have also found a similar psot, please refer to it to see if it helps you.

Solved: Connect to an Outlook distribution list - Power Platform Community (microsoft.com)

If it does not help, please provide more details.

Best Regards
Community Support Team _ Polly

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