topic Unable to connect Power BI and PostgresSQL in Developer

Unable to connect Power BI and PostgresSQL

npatil — Wed, 22 Jun 2022 17:08:26 GMT

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!

Re: Unable to connect Power BI and PostgresSQL

v-chenwuz-msft — Mon, 27 Jun 2022 06:41:15 GMT

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 the validation procedure.'" - Stack Overflow

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.

Re: Unable to connect Power BI and PostgresSQL

npatil — Mon, 27 Jun 2022 18:29:45 GMT

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?

Re: Unable to connect Power BI and PostgresSQL

v-chenwuz-msft — Tue, 28 Jun 2022 08:02:37 GMT

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.