Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

librucha

Cannot connet to Postgresql with SSL certificate chain

Submitted by on ‎08-23-2022 03:21 AM

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
Status: Investigating

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

See more ideas labeled with:
2 Comments (2 New)
Comments
librucha
New Member
‎08-23-2022 03:25 AM

MicrosoftTeams-image.png

 

v-cazheng-msft
Community Support
Community Support
‎08-23-2022 06:34 PM
Status changed to: Investigating

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

Idea Statuses