| title | Set up your PostgreSQL database connection | ||
|---|---|---|---|
| description | This article provides information about how to create a PostgreSQL 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 PostgreSQL database connection.
The PostgreSQL database connector supports the following authentication types for copy and Dataflow Gen2 respectively.
| Authentication type | Copy | Dataflow Gen2 |
|---|---|---|
| Basic (Username/Password) | n/a | √ |
You can connect Dataflow Gen2 in Microsoft Fabric to PostgreSQL database using Power Query connectors. Follow these steps to create your connection:
- Check capabilities to make sure your scenario is supported.
- Complete prerequisites for PostgreSQL database.
- Get data in Fabric.
- Connect to a PostgreSQL database.
[!INCLUDE postgresql-capabilities-supported]
[!INCLUDE postgresql-prerequisites]
[!INCLUDE get-data-data-factory-microsoft-fabric]
[!INCLUDE postgresql-connect-to-power-query-online]