topic Error connecting Postgres with Gateway in Report Server

Error connecting Postgres with Gateway

rinogattuso — Fri, 20 Dec 2024 10:45:57 GMT

I can connect Power BI Desktop to a local Postgres server, so I published a Power BI report and tried to set up a connection on Power BI Cloud with my local gateway that can access Postgres.

If I try to update the semantic model, I receive this error:

Errore dell'origine dati: [ValidateMarkupTags]{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[ccon]Installare Npgsql versione 4.0.16.0</ip> o precedente.[/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10305"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"PostgreSQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"[ccon][ccon]<ip>192.168.0.12</ip>[/ccon]<ip><ip>192.168.0.0</ip></ip>;val_fKOANemvfL[/ccon]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.MissingClientLibrary"}}],"exceptionCulprit":1}}} Table: prodotto.
URI cluster: WABI-WEST-EUROPE-redirect.analysis.windows.net
ID attività: 7a39cf9b-0094-4de7-be3f-2c8be3c19cdc
ID richiesta: 4d229eaa-5fba-68b3-b18c-ab4637ad8aa5
Ora: 2024-12-20 10:32:25Z

I've installed Npgsql version 4.0.16.0 as stated in the error log and restarted the gateway, but I still get the same error.

My gateway is okay because I use it to access Excel files that are on the local network in other Power BI reports.

Sorry if my English is not correct.

Re: Error connecting Postgres with Gateway

lbendlin — Fri, 20 Dec 2024 16:36:24 GMT

Gateway install files do not include the Postgres drivers. You can borrow them from the Desktop install.

From C:\Program Files\Microsoft Power BI Desktop\bin\ADO.NET Providers

to C:\Program Files\On-premises data gateway\m\ADO.NET Providers

everything npgsql

Re: Error connecting Postgres with Gateway

Anonymous — Thu, 26 Dec 2024 02:50:07 GMT

Hi,lbendlin,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hello,rinogattuso .I am gald to help you.
I found the relevant issue link from my browser, hope it helps.
URL:

Power Query PostgreSQL connector - Power Query | Microsoft Learn

And I've noticed that some users try to use the ODBC connector instead of the PostgreSQL connector, but be aware that you'll need to reconfigure the data source and may need to modify the query.
URL:
Solved: Configure Gateway to connect to PostgreSQL - Microsoft Fabric Community
Solved: PostgreSQL connection through On-premise Data Gate... - Page 2 - Microsoft Fabric Community

If you need to use a gateway to connect to PostgreSQL, using ODBC is also a good idea.
Using ODBC is also a suggestion to try.
URL:
PowerBI and PostgreSQL : SSL, Let’s encrypt and Gateway

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

Re: Error connecting Postgres with Gateway

Anonymous — Mon, 30 Dec 2024 09:30:08 GMT

Hi,rinogattuso .Merry Christmas to you.
I subsequently configured the relevant pbix reports according to the official documentation and successfully completed the refresh operation on Service
I hope you find the following test helpful.

My servername: localhost:5432

I use the version :PostgreSQL 17

There was a problem at the beginning.

Requires version 4.0.10 or earlier (do not download newer versions)

Release Npgsql v4.0.10 · npgsql/npgsql · GitHub

Note that you must check the box for

After successful installation restart the computer (you have to restart the computer)

Log in to the power bi service and configure the on process gateway.

When the gateway is set up correctly, the data source credentials issue is automatically resolved as well
PostgreSQL Refresh Successful.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.