Forum Discussion
Data source(postgres) connectivity with powerbi gateway
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 ...
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.
There is a bug in the gateway installers. It is missing the npgsql ADO drivers. Copy them over from the Desktop install.
I have already installed npsql3.2.6 but it's showing same error
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
