Microsoft Exchange Online
|Release State||General Availability|
Power BI (Datasets)
Power BI (Dataflows)
Power Apps (Dataflows)
Dynamics 365 Customer Insights
|Authentication Types Supported||Exchange account
|Function Reference Documentation||Exchange.Contents|
Connect to Microsoft Exchange Online from Power Query Desktop
Power Query Desktop includes Excel, Power BI (Datasets), and Analysis Services as experiences.
To make the connection to Microsoft Exchange Online, follow these steps:
From Get Data, select the Online Services category, select Microsoft Exchange Online, and then select Connect. More information: Where to get data
In the Microsoft Exchange Online window that appears, enter the mailbox address for the account you would like to access.
Choose either Exchange account sign in and provide your credentials, or Microsoft account and sign in.
You can also use a User Principal Name (UPN). It looks similar to an email address. Typical format is user@domain_name.
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.
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:
Select the Microsoft Exchange Online option in the connector selection. More information: Where to get data
Enter the mailbox address for the account you would like to access, and any other connection details if necessary. Select Next.
Select the tables to import, then select Transform Data.
If you'd like, you can filter and refine your data set in this window before loading. When you're ready, select Save & close.
Submit and view feedback for