Forum Discussion
Helper IConnecting to PostgreSQL server credential / certificate errors
Hi,
I've checked with the company that hosts the DB, according to them, the DB settings haven't been changed, so I have the feeling it has to do with PBI itself.
Meanwhile I have used another method to connect to the DB, rather than using the native PostgreSQL connector, I am using the connector 'ODBC'.
= Odbc.DataSource("database=[DB_name];driver={PostgreSQL Unicode(x64)};port=xxxxxx;server=[Domain or IP];sslmode=require;", [HierarchicalNavigation=true])
This took some additional work to re-configure our dashboards but it dit the trick. It isn't a solution to fix the PostgreSQL issue itself, but a good workaround for people encountering the same issues. Still curious how this PostgreSQL issue could be fixed though.
Hi all,
New version with fix has been published to download center Download Microsoft Power BI Desktop from Official Microsoft Download Center (version 2.137.1102.0). It will be updated/available in Microsoft Store in few hours.
Best Regards,
Gao
Community Support Team
Helper IHi,
I've checked with the company that hosts the DB, according to them, the DB settings haven't been changed, so I have the feeling it has to do with PBI itself.
Meanwhile I have used another method to connect to the DB, rather than using the native PostgreSQL connector, I am using the connector 'ODBC'.
= Odbc.DataSource("database=[DB_name];driver={PostgreSQL Unicode(x64)};port=xxxxxx;server=[Domain or IP];sslmode=require;", [HierarchicalNavigation=true])
This took some additional work to re-configure our dashboards but it dit the trick. It isn't a solution to fix the PostgreSQL issue itself, but a good workaround for people encountering the same issues. Still curious how this PostgreSQL issue could be fixed though.
Hi, it is clarified in this thread
Our team spent a day to find out if this was the certificate/db change. September version worked right away!
Anyone who has installed it via Microsoft store - PowerBI tend to be updated automatically. So the update awarness might be low.
They should mention it on their main issues page too.
