Office 365 Exchange Data
O365 mailboxes, DL's, MBX Size, message in/out metrics and details, etc.
Great suggestion, thanks! Who else is looking to analyze Exchange information? If you think it’d be valuable, please add your votes!
Actually, just make all the reports found in the admin centre for o365 available to Power BI REPORT SERVER and desktop app please. I cannot afford your PowerBI service as a non profit small company, so we host our own server under SA license, but we need access to the stats in o365 to be able to demonstrate and prove our o365 uptake and security.
Hello product team!
I would really need to connect on-premis Exchange to PowerBi Service, so please add this functionality to the Gateway. Please :)
Yes please! This would be great!
Ben Stegink commented
Yes, please! Have a client asking for this info right now, this would be really helpful, particularly mailbox size on a per mailbox basis. some of this info can be found already in the PowerBI Office 365 Usage Analytics Report....
Yes, get it done! We need it.
Ofc this is a need, no admin want to look at his own data, only for testing.
Annette Boulter commented
PLease please please ... would be invaluable in understanding what we have outstanding in our inboxes
Absolutely - there are often initiatives surrounding email use and monitoring.
Johan Schmidt commented
Idea was submitted 3 years ago, is it still under review, or could we expect something in the near future? @Will Thompson @MSFT
Any chance of a status update?
I am using power bi desktop for SCSM & SCCM dashboard which works great and shows useful stats for the IT management... now a similar dashboard template for exchange / AD / lync and SQL is really necessary.
for sure itll be very helpful and will encourage more users to use powerbi
The ability to count pages received within email attachments would be awesome.
Ability to connect with archived data would be a huge plus. This way, we do not need a separate data store to save information beyond the period held in MS exchange
This would be great. I'd like to get all my colleagues calendars in one overview so we can stop filling out separate holiday calendars.
Thom McKiernan commented
On-prem exchange too please! I'm having to run powershell to export a CSV of info, then using excel to try and get some analysis from it.
Would be much easier if I could feed it straight to PowerBI through an Exchange connector
We want to use this type of approach for enterprise wide crm style data mining, eg email counts to and from client domains, users corresponding with client domains etc.
we want to know whether office 365 SLA metrics can be enabled in Power BI
Tim Rodman commented
Here's something that you can build by reading an Exchange Calendar: http://www.timrodman.com/a-power-bi-timesheet/
Bernard Chouinard commented
You can get this type of data for O365 by using OData feed in PowerBI Desktop
Enter the O365 reporting Url https://reports.office365.com/ecp/reportingwebservice/reporting.svc/
Choose Basic Authentication, enter user name\password
You will get a list of tables that are available, pick the one you need