Forum Discussion

Mahesh_73's avatar
Mahesh_73
New Member
4 months ago
Solved

Power BI PostgreSQL Connection Issue – SSL Certificate Not Trusted

Hi everyone,

I’m trying to connect PostgreSQL (AWS RDS) to Power BI, but I’m facing an SSL trust issue while loading data.

Here’s what I’ve already done:
- Installed Npgsql
- Configured and installed the AWS RDS root certificate locally
- Set up the On-Premises Data Gateway

Despite this, I’m still getting an error related to:
“The certificate chain was issued by an authority that is not trusted”

I’ve also tried reinstalling the certificate and verifying the connection settings, but no luck so far.

Has anyone faced this issue before or knows how to fix it?
This is quite urgent — any help would be really appreciated.

 

Thanks in advance!

Need Help
  • v-dineshya's avatar
    v-dineshya
    4 months ago

    Hi Mahesh_73 ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    The error “Npgsql.Tls.ClientAlertException: CertificateUnknown: Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.” indicates that, Power BI is successfully connected to PostgreSQL, PostgreSQL does send a certificate, but Windows / Power BI does not trust the root CA. This is local machine trust issue, not PostgreSQL configuration.

     

    Please try below steps to fix the issue.

    1. Install the AWS RDS Root Certificate into Local Computer. Download the latest AWS RDS Root CA, use latest bundle, NOT old rds-ca-2015. global-bundle.pem or region‑specific CA.

    2. Open --> certlm.msc. Install the certificate into: Local Computer
    a. Trusted Root Certification Authorities.
    b. Certificates

    3. Restart the machine --> Restart On‑Premises Data Gateway service --> Restart Power BI Desktop

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

     

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 months ago
    - Installed Npgsql

    Not necessary on the desktop, already included

     

     Set up the On-Premises Data Gateway

    Did you also copy the required files from the desktop to the gateway?

  • v-dineshya's avatar
    v-dineshya
    Community Support
    4 months ago

    Hi Mahesh_73 ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    The error “Npgsql.Tls.ClientAlertException: CertificateUnknown: Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.” indicates that, Power BI is successfully connected to PostgreSQL, PostgreSQL does send a certificate, but Windows / Power BI does not trust the root CA. This is local machine trust issue, not PostgreSQL configuration.

     

    Please try below steps to fix the issue.

    1. Install the AWS RDS Root Certificate into Local Computer. Download the latest AWS RDS Root CA, use latest bundle, NOT old rds-ca-2015. global-bundle.pem or region‑specific CA.

    2. Open --> certlm.msc. Install the certificate into: Local Computer
    a. Trusted Root Certification Authorities.
    b. Certificates

    3. Restart the machine --> Restart On‑Premises Data Gateway service --> Restart Power BI Desktop

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

     

    • v-dineshya's avatar
      v-dineshya
      Community Support
      4 months ago

      Hi Mahesh_73 ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

       

      Regards,

      Dinesh

      • v-dineshya's avatar
        v-dineshya
        Community Support
        4 months ago

        Hi @Mahesh_73 ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

         

        Regards,

        Dinesh