Edit

Share via

Set up your SharePoint list connection

This article outlines the steps to create a SharePoint list connection.

Supported authentication types

The SharePoint list connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Authentication type Copy Dataflow Gen2
Anonymous n/a √
Windows n/a √

Set up your connection for Dataflow Gen2

You can connect Dataflow Gen2 in Microsoft Fabric to SharePoint list using Power Query connectors. Follow these steps to create your connection:

  1. Check capabilities to make sure your scenario is supported.
  2. Get data in Fabric.
  3. Connect to a SharePoint list.

Capabilities

  • Site URL

Get data

To get data in Data Factory:

  1. On the left side of Data Factory, select Workspaces.

  2. From your Data Factory workspace, select New > Dataflow Gen2 to create a new dataflow.

    Screenshot showing the workspace where you choose to create a new dataflow.

  3. In Power Query, either select Get data in the ribbon or select Get data from another source in the current view.

    Screenshot showing the Power Query workspace with the Get data option emphasized.

  4. In the Choose data source page, use Search to search for the name of the connector, or select View more on the right hand side the connector to see a list of all the connectors available in Power BI service.

    Screenshot of the Data Factory Choose data source page with the search box and the view more selection emphasized.

  5. If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.

    Screenshot of the Data Factory Choose data source page displayed after selecting view more, with the list of connectors.

Connect to a SharePoint list

To connect to a SharePoint list:

  1. From the Data sources page, select SharePoint list. For more information, go to Where to get data.

  2. If you have access to the SharePoint site picker, use it to locate and select the sites directly on the connection settings page. If not, copy the SharePoint site URL and paste it into the Site URL text box in the SharePoint list dialog box.

    Screenshot of the online SharePoint list page with the Site URL information filled in.

  3. Enter the name of an on-premises data gateway if needed.

  4. Select the authentication kind, and enter any credentials that are required.

  5. Select Next.

  6. From the Navigator, you can select a location, then transform the data in the Power Query editor by selecting Next.

    Screenshot of the online Navigator where you select the items you want to use.

Set up your connection in a pipeline

Data Factory in Microsoft Fabric doesn't currently support a SharePoint list in pipelines.

Related content

  • Last updated on