Forum Discussion
Unable to disable Encrypt connections
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.
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
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.
4 Replies
- amitchandak
Super User
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
Hi amitchandak , we are using an Azure Database for PostgreSQL flexible server instance which uses version 13.15 of postgres.
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
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.
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.
