Cannot connet to Postgresql with SSL certificate chain

[librucha]

We are using on premise Postgresql server for load data to PowerBI, but when I need use SSL connection to DB, PowerBI throw connection error because certificate is not valid.

Is the problem on the CA chain? CA on index 1 is issuer of certificate but is not root CA or default trusted CA.

Certificate chain
 0 s:CN = *.o2ekc.cz
   i:C = CZ, O = Alpiro s.r.o., CN = AlpiroSSL RSA DV CA

 1 s:C = CZ, O = Alpiro s.r.o., CN = AlpiroSSL RSA DV CA
   i:C = US, ST = New Jersey, L = Jersey City, O = The USERTRUST Network, CN = USERTrust RSA Certification Authority

 2 s:C = US, ST = New Jersey, L = Jersey City, O = The USERTRUST Network, CN = USERTrust RSA Certification Authority
   i:C = GB, ST = Greater Manchester, L = Salford, O = Comodo CA Limited, CN = AAA Certificate Services

[librucha]

[v-cazheng-msft]

Hi @librucha,

May I know whether you configure gateway for your on-premise PostgreSQL data source? Did you install your gateway on the same machine as the PostgreSQL? Did you point your certificate as trust certificate?

For something  related to SSL security error with data source, you could refer to this official blog firstly: SSL Security Error with Data Source | Microsoft Power BI Blog | Microsoft Power BI.

Best Regards,

Community Support Team _ Caiyun