How to get User list having Full Admin Permissions on a shared mailbox using Power BI

[Anonymous]

We are creating a report in power bi which will read data from Microsoft Exchange about shared mailboxes.

We’ve more than 80 shared mailboxes from which we want to read emails and the shared mailbox properties.

I have been able to get the shared email information using Power BI, however I am unable to get the properties like

How many users have Full Admin Permissions on that shared mailbox? Is this something that can be done through Power BI

If yes, please can anyone help me point me in right direction.

Thanks in advance.

Abhinav

[v-angzheng-msft]

Hi, @Anonymous 

May I ask if your problem has been solved? Is the above post helpful to you?

If  it does, could you please mark the post which help as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Best Regards,
Community Support Team _ Zeon Zheng

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

[edhans]

You are limited to what the Exchange Connector provides. I believe for this you'd need to use a PowerShell script to dump a CSV file that you could then consume with Power BI. How to Get Mailbox Permissions with PowerShell - inc. Complete Report (lazyadmin.nl)