Answered

power automate Postgresql connection failed issue

(0) Share

Report

Posted on by khongore

Hi all,

I am encountering a PostgreSQL connection problem in Power Automate, and I have encountered errors as mentioned below screenshot. Could you please assist me in connecting to the PostgreSQL server?

errors:

Test connection failed. Details: An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond' inner exception: An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond' clientRequestId: 654f7255-22dc-da17-3858-9d08cf037704

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

lbendlin 8,649 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Are you sure you don't need a gateway? Is your PostgreSQL server in the Azure cloud?

Was this reply helpful? Yes No
khongore 4 on at

Like (0)

Report
Copy link

Link copied!

1) I'm not certain that I require a gateway. I've attempted various methods and even set up a gateway on my laptop. However, the error I'm encountering is distinct and is prompting me to install ngpsql. Can you help me to install ngpsql?
2) Our PostgreSQL database is operational on an internal server, not on Azure.

Error:
Test connection failed. Details: Please install Npgsql version 4.0.10.0 or earlier. inner exception: Please install Npgsql version 4.0.10.0 or earlier. clientRequestId: 773ee7b2-9598-8262-4117-8e9ad47996d4

Was this reply helpful? Yes No
Verified answer

lbendlin 8,649 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Your database is on-premise so you absolutely need a gateway. A standard (enterprise) gateway, to be exact. Not something you want to install on your laptop.

There is a known issue that the latest gateway installers are missing the npgsql ADO drivers. You will need to install Power BI Desktop and then copy the files over to the gateway.

Was this reply helpful? Yes No
Aysan 271 on at

Like (0)

Report
Copy link

Link copied!

Hi,
This https://community.fabric.microsoft.com/t5/Service/Gateway-error-connecting-to-PostgreSQL/m-p/963650 helped me to resolve the issue , hope it helps

Was this reply helpful? Yes No