Use Power BI to query all mailboxes.

[Tacllem]

Hello and good day to you all.

I am starting out with Power Bi and need a way to report on all mailboxes over my Office 365 exchange server.  The task is to produce reports for the sales department of how many emails sent and received and then how many different domains were sent to.
So far all I can get Power BI to connect to I s a single mailbox when I enter my address.
I am the domain system administrator and have full rights.

Thanks.

[ChrisAtMAF]

A lot of Exchange Admin Center data including a list of mailboxes can be imported via the new REST API by just adding the following to Power Query / Power BI as an OData Feed:

https://outlook.office.com/adminApi/beta/[Azure Active Directory Tenant ID]/

(Where [Azure Active Directory Tenant ID] is in XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX format and found via https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/active-directory-how-to-find-te...)

There is a 'Mailbox' table that worked for my purposes. NB this is marked as 'beta' so be warned about relying on this long-term.

[Anonymous]

Hi.

When importing the Mailbox table I see this error.

In the image below we can better see the errors in the lines

The tables are not populated with data from my Exchange, Can you help me?

[ChrisAtMAF]

Hi @Anonymous ,

I also found that a lot of the API returned Errors - but some data is available (scroll right).

It sounds like you might need email usage reports though. To get those, you might need the 'Creating a Power Query for report data in Excel' section of 

https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35

combined with

https://docs.microsoft.com/en-us/graph/api/reportroot-getemailactivityuserdetail?view=graph-rest-1.0

and https://docs.microsoft.com/en-us/graph/api/reportroot-getemailactivitycounts?view=graph-rest-1.0

Hope this helps,

Chris

[amitchandak]

@Tacllem , refer one of the two can help

https://powerbi.microsoft.com/fr-fr/blog/analyzing-your-microsoft-exchange-account-data-with-power-q...

https://www.youtube.com/watch?v=wvBR41V7_Yk

https://radacad.com/import-email-attachments-directly-into-a-power-bi-report-using-power-query

[Tacllem]

That's for the try but I need to list "ALL MAILBOXES"  not just mine.

Additionally (I know you did not design the system) but requiring excel as a middle step I kind of silly. I will stick with Crystal reports if that's the case.