Copying data gets failed

Hi Anonymous, 

Thanks for using Fabric Community.

The error you're encountering, "Npgsql.NpgsqlException: Exception while reading from stream," indicates that the Dataflow Gen 2 task couldn't establish a stable connection with the PostgreSQL source while copying data to the lakehouse in Fabric. 

There is a default timeout of 30s for requests with a postgres connection. You can add Timeout=600;CommandTimeout=0; to your connection string .

Timeout is to establish the connection, and CommandTimeout is the timeout for the command itself (in second, 0 means infinity)

You can refer to this link for more details:

 https://www.npgsql.org/doc/connection-string-parameters.html

I hope this information helps. Please do let us now if you still have any further questions.

Thanks.