Forum Discussion
app.powerbi.com cannot connect to Aiven PostgreSql Database Server. (SSL validation error)
Hi Power BI team, We are trying to leverage Power-BI to display our data that is hosted in an aiven.io Postgres Database. I have managed to get it working on Power-BI desktop by simply adding...
Thank you both,
Indeed using ODBC with PostgreSQL works fine with Power BI desktop.
However, now that the Postgresql connector works in the desktop app it would be a shame not to use it.
I can confirm that using both odbc or PostgreSQL I am able to publish reports to app.powerbi.com.
However, Dataset refresh and scheduled refresh will only work after I set-up an on-premise gateway. (for both postgresql and odbc data sources).
I understand that odbc requires a gateway to be set-up but is that true for Postgres too ?
We were hoping not to have to spin up a VM specifically for powerbi, so using gateway is going to be an issue.
Thank you,
Nicolas