Forum Discussion

Tjeerd's avatar
Tjeerd
Helper I
1 year ago
Solved

Connecting to PostgreSQL server credential / certificate errors

Hi all,   Since a couple of days we are facing a challenge that we cannot connect to a PostgreSQL server anymore. It was working fine still on tuesday morning, as from wednesday we had these issues...
  • Tjeerd's avatar
    1 year ago

    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.