topic Re: Fabric On-Prem Gateway PostgreSQL Connector – Error Despite Correct Npgsql Version in Pipelines

Fabric On-Prem Gateway PostgreSQL Connector – Error Despite Correct Npgsql Version

gdev701 — Sat, 14 Jun 2025 23:59:07 GMT

Hi everyone,

I'm facing an issue while trying to connect my Azure VM–hosted PostgreSQL (Ubuntu 22.04) to Microsoft Fabric using the on-premises data gateway (installed on a separate Windows 11 Azure VM).

Here’s what I’ve done so far:

Installed the on-premises gateway and verified it's running.
Checked If Npgsql.dll version 4.0.17.0 present in the path: "G:\On-premises data gateway\FabricIntegrationRuntime\5.0\Gateway\sxs\PostgreSqlV2\1.0.0.0\Microsoft.Connectors.PostgreSqlV2\"

Despite all of this, I still get the following error while creating the connection in Fabric:

Any insights or help would be greatly appreciated!

Thanks in advance,
Gurudev

Re: Fabric On-Prem Gateway PostgreSQL Connector – Error Despite Correct Npgsql Version

NandanHegde — Mon, 16 Jun 2025 03:40:34 GMT

Login within the server hosting the gateway and check whether you are able to access the database from within that server and confirm back. Post that we can debug the next steps

Re: Fabric On-Prem Gateway PostgreSQL Connector – Error Despite Correct Npgsql Version

gdev701 — Mon, 16 Jun 2025 05:49:13 GMT

I logged into the Windows VM where the On-Premises Data Gateway is installed. From there, I was able to connect to the PostgreSQL server using pgAdmin with the server's IP address and successfully accessed the databases.

Additionally, I confirmed that port 5432 is reachable using Test-NetConnection.

This confirms that the gateway host VM has proper network connectivity to the PostgreSQL server and the credentials are valid.

Could you please guide me on the next steps to troubleshoot the Fabric connector error?

Re: Fabric On-Prem Gateway PostgreSQL Connector – Error Despite Correct Npgsql Version

v-achippa — Tue, 17 Jun 2025 09:31:59 GMT

Hi gdev701,

Thank you for reaching out to Microsoft Fabric Community.

Thank you NandanHegde for the prompt response.

Thank you for the response and confirming the network connectivity and successful connection using pgAdmin. Based on the error message and the setup this is most likely related to a DLL binding issue with the Npgsql connector in the gateway. Please follow below steps:

Confirm that the Npgsql.dll version is 4.0.17.0, go to properties, details and confirm that the file version is 4.0.17.0. If not download the correct version from the official Npgsql GitHub releases and replace it in the correct directory.
https://github.com/npgsql/npgsql/releases/tag/v4.0.17
Check for any other versions are present in the connector path, if any delete or move them temporarily to avoid binding conflicts.
After confirming the correct version and cleaning up, restart the On-premises data gateway service.
After that please try reconnecting in the fabric.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thanks and regards,

Anjan Kumar Chippa

Re: Fabric On-Prem Gateway PostgreSQL Connector – Error Despite Correct Npgsql Version

Shreya_Barhate — Tue, 17 Jun 2025 07:34:02 GMT

Hi,

You can try resolving this by downloading Npgsql v4.0.10 from the official GitHub release page:

Download the .msi installer from that page and install it. Then try reconnecting via the on-premises data gateway.

ref: Release Npgsql v4.0.10 · npgsql/npgsql · GitHub

🛠️ Note: Npgsql 4.0.10 fixes some minor issues and is recommended for compatibility with Microsoft Fabric's PostgreSQL connector.

If you encounter an error like frontend.iu***, try the following steps:

Uninstall both the On-Premises Data Gateway and Npgsql.
Reinstall them in the correct order:
First, install Npgsql v4.0.10.

Then reinstall the gateway.

Restart the gateway service and try connecting again.

Thanks and Regards,
Shreya

Re: Fabric On-Prem Gateway PostgreSQL Connector – Error Despite Correct Npgsql Version

v-achippa — Fri, 20 Jun 2025 12:29:57 GMT

Hi gdev701,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

Re: Fabric On-Prem Gateway PostgreSQL Connector – Error Despite Correct Npgsql Version

v-achippa — Mon, 23 Jun 2025 12:11:16 GMT

Hi @gdev701,

We wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

Re: Fabric On-Prem Gateway PostgreSQL Connector – Error Despite Correct Npgsql Version

v-achippa — Thu, 26 Jun 2025 13:25:53 GMT

Hi @gdev701,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa