Skip to main content

Power BI

Under Review

Office 365 Exchange Data

Vote (401) Share
Chris Johnson's profile image

Chris Johnson on 28 Jan 2015 08:13:43

O365 mailboxes, DL's, MBX Size, message in/out metrics and details, etc.

Administrator on 28 Jan 2015 09:47:20

Great suggestion, thanks! Who else is looking to analyze Exchange information? If you think it'd be valuable, please add your votes!

Comments (48)
Chris Johnson's profile image Profile Picture

65a98445 53c8-4fb0-bafa-0fa3942a14e4 on 05 Jul 2020 22:16:57

RE: Office 365 Exchange Data

Also, here is a cool idea to turn your calendar into a Timesheet http://blog.stevienova.com/2014/05/22/using-power-query-to-analyze-your-schedule

Chris Johnson's profile image Profile Picture

500d4e9b 8355-42eb-8ff4-6a08ec375099 on 05 Jul 2020 22:13:13

RE: Office 365 Exchange Data

Yes. Would be great to analyze email data. In our company we have alot of error logs and automatic notifications sent via email.

Chris Johnson's profile image Profile Picture

e104978c a02f-4887-a744-ee633ec6c827 on 05 Jul 2020 22:12:46

RE: Office 365 Exchange Data

We would also like to see automatic refresh for the cloud version of exchange

Chris Johnson's profile image Profile Picture

57736f7b 0e89-41d9-abee-39a42fc4ea44 on 05 Jul 2020 22:09:23

RE: Office 365 Exchange Data

That would be great, especially if you running Hybrid config with O365

Chris Johnson's profile image Profile Picture

88160618 25a8-4b99-a980-86819fe395c7 on 05 Jul 2020 22:05:39

RE: Office 365 Exchange Data

Just used the Exchange mailbox connection in the PowerBI desktop tool...disappointed to find that it doesn't include the FROM column...how does PowerBI determine what data is available from the mailbox...

Chris Johnson's profile image Profile Picture

9d3a31cb 6cad-47dc-aba8-7382e8e8985d on 05 Jul 2020 22:03:01

RE: Office 365 Exchange Data

Power Query in Excel has a "From Microsoft Exchange" option that can read email contents in addition to email metrics. It works with my Office 365 account. It would be awesome to have this in Power BI.

Chris Johnson's profile image Profile Picture

092a2fb7 4497-47c8-b8cf-306c6f08ebcd on 05 Jul 2020 22:02:31

RE: Office 365 Exchange Data

yes, lets be clear here. Exchange online as a data source would be wonderful. In the first preview of Power BI I was able to connect on one occasion and have never been able to since. It was a sad day.

Chris Johnson's profile image Profile Picture

93080791 1fb2-47b7-b158-67eea3252ea7 on 05 Jul 2020 22:02:14

RE: Office 365 Exchange Data

allow individual users to connect their owne corporate exchnage mail account to analyse their email data based on preconfigured analytical dashboard, whilst allow businesses to do the same for all email accounts registered on exhange, including office 365 accounts