Edit

Microsoft Exchange Online

  • Article

Summary

Item Description
Release State General Availability
Products Excel
Power BI (Semantic models)
Power BI (Dataflows)
Fabric (Dataflow Gen2)
Power Apps (Dataflows)
Dynamics 365 Customer Insights
Analysis Services
Authentication Types Supported Exchange account
Microsoft account
Function Reference Documentation Exchange.Contents

Capabilities Supported

  • Import

Connect to Microsoft Exchange Online from Power Query Desktop

Power Query Desktop includes Excel, Power BI (semantic models), and Analysis Services as experiences.

To make the connection to Microsoft Exchange Online, follow these steps:

  1. Select Microsoft Exchange Online in the get data experience. The get data experience in Power Query Desktop varies between apps. For more information about the Power Query Desktop get data experience for your app, go to Where to get data.

  2. In the Microsoft Exchange Online window that appears, enter the mailbox address for the account you would like to access.

    Screenshot of the Microsoft Exchange Online dialog, showing a mailbox address added with the format user@domain.com.

  3. Select OK.

  4. Choose either Exchange account sign in and provide your credentials, or Microsoft account and sign in.

    Screenshot of the Microsoft Exchange Online dialog, showing a mailbox account and password entered.

    You can also use a User Principal Name (UPN). It looks similar to an email address. Typical format is user@domain_name.

    Screenshot of the Microsoft Exchange Online dialog.

  5. In Navigator, select the data to import and use in your application. Then select either Load to load the table, or Transform Data to open the Power Query Editor where you can filter and refine the set of data you want to use, and then load that refined set of data.

    Screenshot of the Microsoft Exchange Online navigator, showing calendar and mail selected.

Connect to Microsoft Exchange Online from Power Query Online

Power Query Online includes Power BI (Dataflows) and Customer Insights (Dataflows) as experiences.

To make the connection, take the following steps:

  1. Select the Microsoft Exchange Online option in the get data experience. Different apps have different ways of getting to the Power Query Online get data experience. For more information about how to get to the Power Query Online get data experience from your app, go to Where to get data.

    Screenshot of the choose data source window, with the Online services tab opened and Microsoft Exchange Online selected.

  2. Enter the mailbox address for the account you would like to access, and any other connection details if necessary. Select Next.

    Screenshot of the connect to data source page with the mailbox address user@domain added.

  3. Select the tables to import, then select Transform Data.

    Screenshot of the choose data page with the calendar, mail, and tasks tables selected.

  4. If you'd like, you can filter and refine your data set in this window before loading. When you're ready, select Save & close.

    Screenshot of the transform data page, with some data loaded.