Forum Discussion
Solved
PostgreSQL remote database not reached after publishing report
Hello there, I have a problem with my report and the postgresql database (hosted on Kinsta). With Power BI Desktop no problem, the remote database is correctly reached, and all the indicators a...
Well I finally found a solution:
- Host the database with a new provider and, the most important, ssl on
- Keep crypted connection in the data source in PBI Desktop
- Create ODBC connection like in this article (https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/ ) but no need to install npgsql or download ODBC (windows 11 has now ODBC manager)
- Use this connection with odbc connector in PBI (PostgreSQL connector still not working with this remote database)
- Both tests in PBI Desktop and PBI service are OK!
Thank you so much for these info.
- After a show ssl with psql on the PostgreSQL server the result is: off
- I checked SSL settings in PBI Desktop the encryption is set to false:
If I set to true in PBI Desktop I have an error that the datasource can't connect with an encrypted connexion (which is relevant if ssl is set to false on the server)
What looks strange is that ssl is off, data source not encrypted on PBI Desktop (and works well) but PBI service try an encrypted connexion after the rapport been published.
Maybe should I try to add Encrypt=False in the connection string but I don't know where to put it.
Well I finally found a solution:
- Host the database with a new provider and, the most important, ssl on
- Keep crypted connection in the data source in PBI Desktop
- Create ODBC connection like in this article (https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/ ) but no need to install npgsql or download ODBC (windows 11 has now ODBC manager)
- Use this connection with odbc connector in PBI (PostgreSQL connector still not working with this remote database)
- Both tests in PBI Desktop and PBI service are OK!