Set up your Azure Synapse Analytics connection
This article outlines the steps to create an Azure Synapse Analytics connection.
Supported authentication types
The Azure Synapse Analytics connector supports the following authentication types for copy and Dataflow Gen2 respectively.
| Authentication type | Copy | Dataflow Gen2 |
|---|---|---|
| Basic | √ | √ |
| Organizational account | √ | √ |
| Service principal | √ | √ |
Set up your connection in Dataflow Gen2
Data Factory in Microsoft Fabric uses Power Query connectors to connect Dataflow Gen2 to Azure Synapse Analytics. The following links provide the specific Power Query connector information you need to connect to Azure Synapse Analytics in Dataflow Gen2:
- To get started using the Azure Synapse Analytics connector in Dataflow Gen2, go to Get data from Data Factory in Microsoft Fabric.
- Be sure to install or set up any Azure Synapse Analytics prerequisites before connecting to the Azure Synapse Analytics connector.
- To connect to the Azure Synapse Analytics connector from Power Query, go to Connect to Azure Synapse Analytics 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.