How to Connect to Office 365 and report on entire company email usage (by User)

[Anonymous]

My company has requested that I create a Power Bi Report that reports the entire company email usage down to the associate.

Example:

User	Date	Sent	Received	Unread
John Smith	4/14/2020	25	12	3
Jane Doe	4/14/2020	2	18	18

How can I connect to the exchange server, azure, office 365 or anything  to do this?

I did install the Microsoft 365 Usage Analytics application but it doesnt drill down to the employee.

Can anyone direct me in the right direction

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

To enable owner audit logging function may help you fulfill what you need.

Owner mailbox audit logging

By default. owner audit logging is not turned on. It should only be used if you have to investigate an action by the owner of the mailbox. It should be used for a limited time period, approximately two weeks. This is because the audit log entries are stored in the mailbox, and this may cause the mailbox dumpster to exceed the size limit.

Here is the reference.

https://docs.microsoft.com/en-us/office365/troubleshoot/audit-logs/mailbox-audit-logs

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Greg_Deckler]

That's...interesting...

There is an Exchange connector although perhaps the Office 365 audit logs?