Edit

Share via

Set up your Azure Synapse Analytics connection

This article outlines the steps to create an Azure Synapse Analytics connection in Microsoft Fabric.

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 for Dataflow Gen2

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

  1. Check capabilities to make sure your scenario is supported.
  2. Complete prerequisites for Azure Synapse Analytics.
  3. Get data in Fabric.
  4. Connect to Azure Synapse Analytics.

Capabilities

  • Import

Prerequisites

Before you can sign in to Synapse workspaces, you must have access to Azure Synapse Analytics Workspace.

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 Azure Synapse Analytics

To make the connection from Power Query Online:

  1. Select the Azure Synapse Analytics (SQL DW) option in the connector selection.

  2. In the Azure Synapse Analytics (SQL DW) dialog that appears, provide the name of the server and database (optional). In this example, testazuresqlserver is the server name and AdventureWorks2012 is the database.

    Screenshot of the Connect to data source page where you enter the online connection information.

    You can also select and enter advanced options that modify the connection query, such as a command timeout or a native query (SQL statement). More information: Connect using advanced options

  3. If you're connecting to this database for the first time, select the authentication kind and input your credentials.

  4. Select Next to continue.

  5. In Navigator, select the data you require, and then select Transform data.

More information

Related content

  • Last updated on