Set up your PostgreSQL database connection

This article outlines the steps to create a PostgreSQL database connection.

Supported authentication types

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	√

Set up your connection in Dataflow Gen2

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

1. Get data from Data Factory in Microsoft Fabric.
2. Set up PostgreSQL database prerequisites.
3. Connect to a PostgreSQL database (from Power Query Online).