Forum Discussion
Use Power BI to query all mailboxes.
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-tenant)
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.
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?
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
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