Data source(postgres) connectivity with powerbi gateway

[Anonymous]

We are trying to connect with postgres sql which is hosted at cantos machine on premise server. On windows machine we have installed the power bi gateway and where database is accessable. This error is been coming from app.powerbi.com. Please help us. 

Underlying error code: -2147467259
Underlying error message: Please install Npgsql version 4.0.10.0 or earlier.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: PostgreSQL

[Nitin_1703]

i am also facing same issue, whereas i am using single gateway for SQL & PG, SQL Reports are working fine, but PG Connection is not working with same error.

[lbendlin]

There is a bug in the gateway installers. It is missing the npgsql ADO drivers. Copy them over from the Desktop install.

[Nitin_1703]

I have already installed npsql3.2.6 but it's showing same error 

[lbendlin]

That is unrelated and unnecessary.  You need to copy the npgsql files from the Desktop install to the gateway install.

Alternatively, use this https://github.com/npgsql/npgsql/releases/tag/v4.0.10

[Nitin_1703]

Yes Now I am Connected but My Data tables are not Showing

[lbendlin]

Did you uninstall 3.2.6?

[Nitin_1703]

No I have just updated Version 4.0.10

[lbendlin]

you may want to clean that up to make sure there are no residuals of the older (or newer!) versions.

[Nitin_1703]

Yes You are right, I have just updated my desktop version now its showing Data.

[Anonymous]

The problem is been resolved by using ODBC connectivity and its not related to the version changes. Thanks for your support.

[v-yuaj-msft]

Hi @Anonymous ,

Based on your description, it may be that the version you are currently using cannot match Power BI Service. You can try to install the previous version and then connect to the data source.

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Its not the version the causes the problem. Its something else that is creating the issue.

[lbendlin]

Which Npgsql version is installed on the gateway?

[Anonymous]

The same version we are using.