Unable to disable Encrypt connections

[milletf1]

Hello,

I am trying to disable Encrypt connections in the permissions for a postgres database that is hosted in Azure, but I can't figure out where I'm going wrong. I suspect this could be a bug but am relatively new to Power BI so it might not be. I have done the following:

1. Click Get data -> More

2. Select Azure Database for PostgreSQL.

3. Enter Server and Database. Click OK.

4.  Enter User name and Password. Click OK.

5. Unable to connect dialog is displayed with details: "An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'". Click cancel.

6. Click File -> Options and settings. Click Data source settings.

7. Select the server from step 3 and click Edit Permissions.

8. Uncheck "Encrypt connections" and click Ok.

At this point I would assume that I can select the data source from the Recent sources dropdown, but unfortunately I can't. Since I don't have that option I go through steps 1 - 4 but I still get the same certificate is invalid error. Additionally, when I go back to Data source settings the Encrypt connections checkbox is checked despite the fact that I have previously unchecked it.

How do I work around this? I can't select the data source even though there are some settings for it, and when I try to get data using the same credentials, it completely ignores the permissions I have set for the data source.

[milletf1]

I've managed to establish a connection to my database with ODBC using the process described  here Solved: How to fix Invalid Certificate on postgresql serve... - Microsoft Fabric Community. Note that I had to add `SSLMode=require` to the connection string before it would work.

[v-yangliu-msft · Accepted solution]

Thanks for the reply from amitchandak , please allow me to provide another insight: 
Hi  @milletf1 ,

You can check the solutions for the same error message below and try connecting to AWS via SSL by setting the relevant information: 

Solved: Connecting to PostgresSQL hosted on AWS RDS? - Microsoft Fabric Community

Alternatively, you can try using ODBC to connect to PostgreSQL.

Solved: How to fix Invalid Certificate on postgresql serve... - Microsoft Fabric Community

This is the related document, you can view this content:

Solved: The remote certificate is invalid according to the... - Microsoft Fabric Community

database - Power Bi PostgreSQL data import error - The remote certificate is invalid according to th...

postgresql - AWS RDS Postgres Connection issue to Microsoft Power BI: "The Remote certificate is inv...

windows - An error happened while reading data from the provider. The remote certificate is invalid ...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@milletf1 , what is a version of Postgresql you are using? A configuration file is required for version 16 at the server end. We faced the same issue with that version.

I will check and share the details, once you confirm the version

[milletf1]

Hi @amitchandak , we are using an Azure Database for PostgreSQL flexible server instance which uses version 13.15 of postgres.