Issue about connecting to a on-premise PostgreSQL source to implement a copy activity

[pmscorca]

Hi,

I need to copy data from a PostgreSQL source using a data pipeline.

In order to implement it, on my machine I've installed PostgreSQL vers. 17.2 and created a test database.

Moreover, I've installed and configured an on-premise data gateway.

Then, I've created a data pipeline and selected a copy activity: for the data source I've specified PostgreSQL database,

indicating the server name and the database name, the basic authentication, the user name and the related password,

but it isn't possible to create the connection successfully for an exception that says to install Npgsql vers. 4.0.16 or earlier.

Now, how could I solve a such issue, please? Thanks

[NandanHegde · Accepted solution]

Similar threads:

https://community.fabric.microsoft.com/t5/Service/An-exception-occurred-Please-install-Npgsql-versio...

https://community.fabric.microsoft.com/t5/Service/Gateway-error-connecting-to-PostgreSQL/m-p/963650

https://stackoverflow.com/questions/34020719/installing-ngpsql-to-use-postgresql-in-powerbi

[pmscorca]

Hi, thanks for your reply.

I've solved installing npgsql vers. 4.0.16 in the GAC (Global Assembly Cache) and then creating a gateway.

The similar threads are related to Power BI, not Fabric data pipeline.

Thanks

[NandanHegde]

The concept of onpremises dara gateway remains the same across powerbi or data pipelines.  Same gateway is leveraged by both