How to create a Microsoft 365 connection

This article outlines the steps to create a Microsoft 365 connection.

Supported authentication types

This Microsoft 365 connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Authentication type	Copy	Dataflow Gen2
Service principal	√	n/a

Set up your connection in Dataflow Gen2

The Microsoft 365 connector isn't currently supported in Dataflow Gen2.

Set up your connection in a data pipeline

To create a connection in a data pipeline:

1. From the page header in Data Integration service, select Settings > Manage connections and gateways.

   

2. Select New at the top of the ribbon to add a new data source.

   

   The New connection pane is displayed on the left side of the page.

   

Setup connection

Step 1: Specify the new connection name, type

In the New connection pane, choose Cloud, and then specify the following fields:

• Connection name: Specify a name for your connection.
• Connection type: Select Microsoft 365 for your connection type.

Step 2: Select and set your authentication

Under Authentication method, select your authentication from the drop-down list and complete the related configuration. This Microsoft 365 connector supports the following authentication types.

Service Principal

Service Principal authentication

• Tenant Id: Your service principal tenant ID. Specify the tenant information under which your Microsoft Entra web application resides.
• Service principal ID: Specify the application's client ID.
• Service principal key: Specify the application's key.

Step 3: Specify the privacy level that you want to apply

In the General tab, select the privacy level that you want apply in the Privacy level drop-down list. Three privacy levels are supported. For more information, go to privacy levels.

Step 4: Create your connection

Select Create. Your creation is successfully tested and saved if all the credentials are correct. If not correct, the creation fails with errors.

Table summary

The connector properties in the following table are supported in pipeline copy:

Name	Description	Required	Property	Copy
Connection name	A name for your connection.	Yes		✓
Connection type	Select Microsoft-365 for your connection type.	Yes		✓
Authentication	Go to Authentication	Yes		Go to Authentication

Authentication

The following table contains the supported authentication type properties.

Name	Description	Required	Property	Copy
Service Principal				✓
- Tenant ID	Your service principal tenant ID. Specify the tenant information under which your Microsoft Entra web application resides.	Yes
- Service Principal ID	Specify the application's client ID.	Yes
- Service Principal key	Specify the application's key.	Yes

Related content

• How to configure Microsoft 365 in a copy activity