| title | Set up your SQL Server database connection | ||
|---|---|---|---|
| description | This article provides information about how to create a SQL Server database connection in Microsoft Fabric. | ||
| ms.topic | how-to | ||
| ms.date | 03/13/2026 | ||
| ms.custom |
|
||
| ai-usage | ai-assisted |
This article outlines the steps to create a SQL Server database connection.
The SQL Server database connector supports the following authentication types for copy and Dataflow Gen2 respectively.
| Authentication type | Copy | Dataflow Gen2 |
|---|---|---|
| Basic (Username/Password) | √ | √ |
| Organizational account | √ | √ |
| Service principal | √ (Only for SQL Server on Azure VMs) | √ |
| Windows | √ (When use on-premises data gateway) | √ |
| Workspace identity | n/a | √ |
You can connect Dataflow Gen2 in Microsoft Fabric to SQL Server database using Power Query connectors. Follow these steps to create your connection:
- Check capabilities, limitations, and considerations to make sure your scenario is supported.
- Get data in Fabric.
- Connect to SQL Server database.
[!INCLUDE sql-server-capabilities-supported]
[!INCLUDE get-data-data-factory-microsoft-fabric]
[!INCLUDE sql-server-connect-to-power-query-online]
[!INCLUDE sql-server-limitations-and-considerations]