Forum Discussion

Tjeerd's avatar
Tjeerd
Icon for Helper I rankHelper 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...
Need Help
  • Tjeerd's avatar
    Tjeerd
    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.

  • Tjeerd's avatar
    Tjeerd
    Icon for Helper I rankHelper I
    1 year ago

    Hi Anonymous, thanks for the update. I must say I find it a very big nuisance that PBI just implements these changes resulting in daily used dashboards not functioning correctly. It consumed many hours for us to investigate this issue, finally resolving it ourself by an alternative approach using ODBC. 

     

    Still, highly appreciate your efforts!