Power Automate: Troubleshooting for connecting to local PostgreSQL (requires Npqsql 4.0.17.0 to be installed)

Recently, when using Power Automate to connect to PostgreSQL 17 through a local gateway, it prompted me to install Npqsql 4.0.17.0 or earlier.

I installed 4.0.17.0 as prompted, but still got the same error. I also replaced all the DLL files under the local gateway program. Nothing helped.

The similar cases can be traced several years ago, most of them were for Power BI topic with PostgreSQL.

I checked the official website:

PostgreSQL connector requires NPGSQL ADO.NET provider 4.0.10 to be installed.

Well, that’s inconsistency.

Got it work

I hope this helps others who encounter similar errors.