Set up your SharePoint folder connection

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

Supported authentication types

The SharePoint folder 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 in Dataflow Gen2

Data Factory in Microsoft Fabric uses Power Query connectors to connect Dataflow Gen2 to a SharePoint folder. The following links provide the specific Power Query connector information you need to connect to a SharePoint folder in Dataflow Gen2:

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.

Set up your connection in a data pipeline

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