Forum Discussion
Postgres Connector Invalid Certificate and Auto Refresh via Cloud Connection
I'm struggling with the Postgres Connector.
I have SSL certificates installed and configured. They seem to be set up correctly since an encrypted DB connection works fine in DBeaver.
However, when I make an encrypted connection in PowerBI Desktop, it fails to refresh with the error: "The remote certificate is invalid according to the validation procedure." I can refresh the data source using the unencrypted connector, but I still can't make an automatic refresh via Cloud Connection in PBI Service (same error).
I've tried using older versions of PBI Desktop (July, August 2024), but it didn't help.
I know I can use an ODBC connector as an alternative, and I've tested it successfully. However, I prefer using the Cloud Connection for automatic refreshes which is not applicable for the ODBC connector.
Is there a way to make the Postgres Connector work? I would really appreciate any help! Thank you!
As far as I am aware, it is not possible to create a cloud connection to the PostGres server at the moment. You will have to use an ODBC connector.
4 Replies
As far as I am aware, it is not possible to create a cloud connection to the PostGres server at the moment. You will have to use an ODBC connector.
Hello GilbertQ, thank you for your response! Is there any official information about it, cause I couldn't find any 😞
Here is the details from the power query documentation where it states that the connection that has to use to connect. Power Query PostgreSQL connector - Power Query | Microsoft Learn
Hi chvladimirova,
Thank for reaching out in Microsoft Community Forum.
I trust GilbertQ, response is accurate and will address your issue.
If you have any further questions or updates regarding your issue, feel free to ask, and we will look into that.If the Super User's answer meets your requirements, please consider marking it as the "Accept as Solution" and click on "Yes"
Please continue using Microsoft community forum.
Regards,
Pavan.
