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