Unable to connect Power BI and PostgresSQL

[npatil]

Trying to connect Power BI to PostgresSQL database but getting the error- : "An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"

Attaching the screenshot for reference. Can somebody please help me with it. Thanks!

[npatil]

Hi, thanks for the suggestion. I am still getting the error. Is there a way to schedule call with the support team for the issue?

[v-chenwuz-msft]

Hi @npatil ,

If you can connect the PostgresSQL via other tools, you can create a support ticket from here.

Support | Microsoft Power BI

Best Regards

Community Support Team _ chenwu zhu

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

[v-chenwuz-msft]

Hi @npatil ,

Many reasons can cause this error.

Please make sure your connection information is correct and that you have not filled in the wrong service name of the PostgresSQL.
It could be that the certificate is expired, please check, or check if your local time and the remote server's time match.

Or you can refer these answers in this post:

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

Best Regards

Community Support Team _ chenwu zhu

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