Edit

Share via

How to create a Microsoft 365 connection

  • Article

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.

    Screenshot showing how to open manage gateway.

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

    Screenshot showing the '+ new' page.

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

    Screenshot showing the 'New connection pane.

Setup connection

Step 1: Specify the new connection name, type

Screenshot showing how to set new connection.

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

Screenshot of the authentication method of Microsoft 365.

Service Principal authentication

Screenshot of the Service Principal authentication method of Microsoft 365.

  • 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.

Screenshot of the connection page.

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