Connect postgreSQL to power BI web

[AGUS]

Hi!

I was able to connect PowerBI to Postgres on Desktop, but when I view it in the web/cloud verison it gives me the error: "Failed to update data source credentials:  The PostgreSQL source doesn't support encrypted connections."

I'm already using a gateway with my PC and it works with connection with MySQL.

How can I get the connection with PostgresSQL to work on PowerBI web?

Thank you.

[collinq]

Hi @AGUS ,

This article explains how to connect to PostgreSQL

Power Query PostgreSQL connector | Microsoft Docs

[AGUS]

Hi,

I have the connection at desktop level but when I upload it to Power BI web the connnetion is lost.

This is the message when I try to configure it:

I don't know how to do it.

Thank you

[collinq · Accepted solution]

Hi @AGUS ,

I am not an expert in doing it in the gateway, but this article appears to show the gateway setup.

PostgreSQL data refresh using Data Gateway in Power BI report | by Ramu Vudugula | Medium

[AGUS]

Thank you very much!

[RaissHajar]

Hello @AGUS , 
I face the same issue. Is the gateway a solution to the problem? 
Thank you in advance for your answer 

[AGUS]

Hello @RaissHajar 

I found a solution. I set up an ODBC connection with postgress in the computer with the gateway. It´s a poor solution because you need to have this computer always on and internet conneted.

https://ramvudugula9.medium.com/postgresql-data-refresh-using-data-gateway-in-power-bi-report-ac8095...

I highly recomend to use databricks.

[RaissHajar]

Thank you so much for your answer @AGUS . 
I implemented the solution and it works with my on-prem DB. 
I will also explore Databricks.