Connect to PostgreSQL invalid certificate. Desktop works, app does not work

[Ruud_BMair]

Hi,

I've created a database and graphs locally in PowerBI desktop using the data from a PostgreSQL database. When this model is published and it then tries to update its data, I get an invalid certificate error. I've checked the settings and Encryption is turned to off, just like locally. 

Locally in PowerBI it works.

This is the full error:

[ValidateMarkupTags][ccon]DataSource.Error: An error happened while reading data from the provider: '[ccon]The remote certificate is invalid according to the validation procedure.[/ccon]'. DataSourceKind = [ccon]PostgreSQL[/ccon]. DataSourcePath = [ccon]server:port;database[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: table.

[lbendlin]

You need a gateway, and the gateway cluster members need to be set up with the npgsql driver.

[johnbasha33]

@Ruud_BMair 

The error message you're encountering, "The remote certificate is invalid according to the validation procedure," indicates that there's an issue with the SSL certificate used by the PostgreSQL server. This issue occurs when Power BI Service tries to connect to your PostgreSQL database but encounters an SSL certificate that it cannot validate.

To resolve this issue, you have a few options:

1. **Use a Valid SSL Certificate:** Obtain and install a valid SSL certificate from a trusted Certificate Authority (CA) on your PostgreSQL server. This ensures that the certificate presented by the server during SSL/TLS handshake is trusted by Power BI Service.

2. **Bypass SSL Certificate Validation:** This is not recommended for production environments due to security risks, but you can temporarily bypass SSL certificate validation in Power BI Service. To do this, you need to add the `sslmode=disable` parameter to the connection string in your Power BI report. However, keep in mind that this disables SSL certificate validation, making your connection less secure.

3. **Ensure Correct Connection String:** Double-check the connection string used in your Power BI report to ensure it includes all necessary parameters and is correctly formatted. Ensure that the server, port, and database name are specified correctly.

4. **Firewall and Network Configuration:** Ensure that there are no firewall rules or network configurations blocking connections between Power BI Service and your PostgreSQL server. Check if there are any network-level restrictions preventing the SSL handshake from completing successfully.

5. **Contact Your IT or Database Administrator:** If you're unsure about SSL certificate configuration or connection settings, reach out to your IT department or database administrator for assistance. They can provide guidance on SSL certificate setup and ensure that the PostgreSQL server is configured to accept connections from Power BI Service.

By addressing the SSL certificate validation issue, you should be able to resolve the error and successfully update the data in your Power BI report from your PostgreSQL database when published to Power BI Service.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!