Unable to connect connection credential in Power BI server from Postgres

[Anonymous]

Hi All,

I have a postgres as key data source, and had download on-premises data gateway (personal mode) with aim to schedule refresh the data.

I do have username and password in Postgres, but when I try update data source in data gateway in Power BI server, it keep fail.  I try to create a new source but have identical message in below

Thanks.

Regards,

Thomas

[Anonymous · Accepted solution]

Thanks lbendin.

I finally create ODBC driver for Postgres and adjust desktop data source directly from Postgres to ODBC.  Then on-premises data gateway can connect with ODBC for schedule refresh.

[lbendlin]

Invest the time to install the native driver. It should have better performance.

[Anonymous]

Thanks Ibendlin.
You mean to let on-premises data gateway directly connect with Postgres to complete the schedule refresh task ? Do I add data source (Postgres) at data gateway (I don't know which folder I should locate to in Connector field, is it the folder where Postgres was locate ?) or at Power bi server (I try create a new data source but somehow throwing the error message in initial post) ?

Thanks.

[lbendlin]

None of the above.  You would need to install the PostGres driver on all gateway cluster members. Either borrow the driver from Power BI Desktop or install the driver from the PostGres site.

[lbendlin]

PostGreSQL drivers are not installed by default on the gateway. You need to add these manually.