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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Tjeerd ,

 

Try creating a Postgre SQL connection using Npgsql version 4.0.10 and check if this resolves the connection issue at the desktop.

The blog refers to SQL Server certificates, which should have nothing to do with your issue.

Are you using Npgsql 4.0.16 version? There is a issue related to this, if I hear anything I will reply below.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

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

Hi Anonymous ,

 

How do I connect using Npsql v4.0.10? I installed it using the .msi, but it still is not working unfortunately.