Using Power Query to Parse your Inbox

One of the nice new features that was added to Power Query with the latest update in December is the ability to connect to Microsoft Exchange as a data source.  You can download this update now here:

http://www.microsoft.com/en-ca/download/details.aspx?id=39933

Here’s a quick demonstration of how you may use the Microsoft Exchange data source in a Power BI solution:

After downloading and installing Power Query launch Excel and navigate to the Power Query tab.  If you don’t see the Power Query tab you may need to turn on the feature, which I describe here. From the Power Query Tab select From Other Sources and pick FromMicrosoft Exchange.

Next you must provide your Microsoft Exchange credentials.

It will then prompt you to authorize Power Query to access your account.

Once the authentication completes the Navigator pane will launch with a view of your Exchange account.

In the Navigator pane you…