Power BI outlook

[jakobt]

Hi,
I am responsible for monitoring a mailbox at my company.
I want to develop a report to show a few KPI's each month including:
- How many emails have we received.
- Who are the top 10 senders
- How many requeries did we solve - i.e. emails updated with category: Complete
- How many emails did we receive by subfolders.

Would anyone know if it is possible to integrate outlook data into POWER BI, and setup a dashboard (report) which can be generated each month?

 

[Matt Allington]

Yes, you can do this with Power Query. There is a standard Outlook connector that can load the data you need. This article will get you started, but is not exactly what you need. You will see you can connect to mail, too.

Create a Planning View of Your Outlook Diary in Power BI

I was chatting to my wife the other day discussing all the things we want to do next year. It has long been a pain in the butt to get a high level (big picture) view of your Outlook diary to see what is happening (think forest, not trees). In [...]Read More »

exceleratorbi.com.au