Skip to main content

Power BI

Under Review

Office 365 Exchange Data

Vote (418) 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 (51)
Chris Johnson's profile image Profile Picture

Scott H on 05 Jul 2020 22:35:16

RE: Office 365 Exchange Data

really need this feature to work with shared mailboxes.

Chris Johnson's profile image Profile Picture

Kjetil on 05 Jul 2020 22:34:56

RE: Office 365 Exchange Data

I'd like to use Power BI/Power Query to have a dashboard of the contents of exchange.

Chris Johnson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:34:42

RE: Office 365 Exchange Data

agreed

Chris Johnson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:34:42

RE: Office 365 Exchange Data

hello yes I have two large US tenants that need to scope their exchange mailbox data for a massive project, using powershell to do this is difficult since I get throttled and I have to break down the queries by 200-300 MBX doing this for over 50k users have been very labor intensive

Chris Johnson's profile image Profile Picture

Sam on 05 Jul 2020 22:34:39

RE: Office 365 Exchange Data

Ability to analyze exchange data from online archives, currently I can only see information of the mailbox, and not of the associated archive mailbox.

Chris Johnson's profile image Profile Picture

Kyle on 05 Jul 2020 22:32:31

RE: Office 365 Exchange Data

There's an exchange data connector in Power BI currently, but I cannot find a way to make it query my entire exchange organization. It just wants to query one mailbox at a time in-depth. I'd love to have the option to get some high level analytics information for my entire organization, such as emails sent and received per user per day. We have productivity dashboards in place now with all sorts of good information, so the ability to add in one more "perspective" on how email is handled would be awesome.

Hopefully this feature request is still being monitored and worked on since it's marked "under review", even though technically an exchange data connector appears to have been added to Power BI at some point after the original user made the request.

Chris Johnson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:27:44

RE: Office 365 Exchange Data

Ability to collect Calendar Events for all or select individuals vs. one individual as it is currently set up for. We have a unique domain that captures calendar events and to pull the data I have to change the login ID/Password save to excel and import into sql to further analyze the data. This would help our call center

Chris Johnson's profile image Profile Picture

Carl on 05 Jul 2020 22:23:05

RE: Office 365 Exchange Data

Looking to use Power BI/Power Query to have a dashboard of the contents of exchange to show stakeholders as part of an exchange migration project.

Chris Johnson's profile image Profile Picture

andre correia on 05 Jul 2020 22:19:44

RE: Office 365 Exchange Data

i can't refresh my exchange data from the power bi web app. This should be implemented, because allowing only to have a manual solution on power bi desktop doesn't make any sense for this type of data

Chris Johnson's profile image Profile Picture

Doug M. on 05 Jul 2020 22:18:27

RE: Office 365 Exchange Data

This would be huge, especially for use with sqlbi.com's Synoptic Panel visualization. We are working on a conference room availability report, and this is the data source we need.