title | description | author | ms.author | ms.topic | ms.date | ms.custom | |||
---|---|---|---|---|---|---|---|---|---|
Set up your SharePoint Online List connection |
This article provides information about how to create a SharePoint Online List connection in Microsoft Fabric. |
pennyzhou-msft |
xupzhou |
how-to |
11/15/2023 |
|
This article outlines the steps to create a SharePoint Online List connection.
The SharePoint Online List connector supports the following authentication types for copy and Dataflow Gen2 respectively.
Authentication type | Copy | Dataflow Gen2 |
---|---|---|
Organizational account | n/a | √ |
Service Principal | √ | √ |
Data Factory in Microsoft Fabric uses Power Query connectors to connect Dataflow Gen2 to a SharePoint Online List. The following links provide the specific Power Query connector information you need to connect to a SharePoint Online List in Dataflow Gen2:
- To get started using the SharePoint Online list connector in Dataflow Gen2, go to Get data from Data Factory in Microsoft Fabric.
- To determine the URL to use to access your SharePoint Online list, go to Determine the site URL.
- To connect to the Azure Blobs connector from Power Query, go to Connect to a SharePoint Online list from Power Query Online.
In some cases, the Power Query connector article might include advanced options, troubleshooting, known issues and limitations, and other information that could also prove useful.
To create a connection in a data pipeline:
-
From the page header in Data Factory service, select Settings
> Manage connections and gateways.
:::image type="content" source="media/connector-common/manage-connections-gateways.png" alt-text="Screenshot showing how to open manage gateway.":::
-
Select New at the top of the ribbon to add a new data source.
:::image type="content" source="./media/connector-common/add-new-connection.png" alt-text="Screenshot showing the '+ new' page." lightbox="./media/connector-common/add-new-connection.png":::
The New connection pane appears on the left side of the page.
:::image type="content" source="./media/connector-common/new-connection-pane.png" alt-text="Screenshot showing the 'New connection' pane." lightbox="./media/connector-common/new-connection-pane.png":::
:::image type="content" source="media/connector-sharepoint-online-list/connection-details.png" alt-text="Screenshot showing how to set new connection.":::
In the New connection pane, choose Cloud, and specify the following fields:
- Connection name: Specify a name for your connection.
- Connection type: Select SharePoint for your connection type.
- URL: The SharePoint Online site URL, for example
https://contoso.sharepoint.com/sites/siteName
.
Under Authentication method, select your authentication from the drop-down list and complete the related configuration. The SharePoint Online List connector supports the following authentication types.
:::image type="content" source="media/connector-sharepoint-online-list/authentication-method.png" alt-text="Screenshot showing that authentication method of SharePoint Online List.":::
Select Service Principal under Authentication method, and fill in the required properties.
:::image type="content" source="media/connector-sharepoint-online-list/authentication-service-principal.png" alt-text="Screenshot showing that service principal authentication method.":::
- Tenant Id: The tenant ID under which your application resides.
- Service principal ID: The Application (client) ID of the application registered in Microsoft Entra ID. Refer to Prerequisites for more details, including the permission settings.
- Service principal key: The application's key.
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.
Select Create. Your creation is successfully tested and saved if all the credentials are correct. If not correct, the creation fails with errors.
:::image type="content" source="./media/connector-sharepoint-online-list/connection.png" alt-text="Screenshot showing connection page." lightbox="./media/connector-sharepoint-online-list/connection.png":::
The following table contains the connector properties supported in a pipeline copy.
Name | Description | Required | Property | Copy |
---|---|---|---|---|
Connection name | A name for your connection. | Yes | ✓ | |
Connection type | Select SharePoint for your connection type. If no connection exists, then create a new connection by selecting New. | Yes | ✓ | |
URL | The SharePoint Online site URL, for example https://contoso.sharepoint.com/sites/siteName . |
Yes | ✓ | |
Authentication | Go to Authentication | Yes | Go to Authentication | |
Privacy Level | The privacy level that you want to apply. Allowed values are Organizational, Privacy, Public | Yes | ✓ |
The following table contains the supported authentication type properties.
Name | Description | Required | Property | Copy |
---|---|---|---|---|
Service Principal | ✓ | |||
- Tenant ID | The tenant ID under which your application resides. | Yes | ||
- Service Principal ID | The Application (client) ID of the application registered in Microsoft Entra ID. Refer to Prerequisites for more details including the permission settings. | Yes | ||
- Service Principal key | The application's key. | Yes |