Some Of my PostgreSql database not refreshing

[arvindyadav]

Hi Team,

I have 5 Postgresql database which is linked to Power BI,  from this 5 database one of my databases are showing error like 

(Failed to update data source credentials: An error happened while reading data from the provider: 'Npgsql.Tls.ClientAlertException: CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider. . The specified hostname was not present in the certificate. at Npgsql.Tls.TlsClientStream.ParseCertificateMessage(Byte[] buf, Int32& pos) at Npgsql.Tls.TlsClientStream.TraverseHandshakeMessages() at Npgsql.Tls.TlsClientStream.<GetInitialHandshakeMessages>d__43.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Npgsql.Tls.TlsClientStream.<PerformInitialHandshake>d__72.MoveNext()')

And rest of them working fine so what is the reason behind this?

I have downloaded Npgsql as well I have added root certification too.

And actually the above database is also working fine in past 10 ago but now it is showing error like this.

please help me.

Regards,

Arvind.

[v-chuncz-msft]

@arvindyadav,

You may take a look at link below.

https://community.powerbi.com/t5/Desktop/Get-Data-from-Postgres-Certificate-Error/m-p/233363

[arvindyadav]

Hi @v-chuncz-msft,

It won't help for me.

When I connect from ODBC I am getting an error like:-

Details: "ODBC: ERROR [HY000] [Qlik][ODBC PostgreSQL Wire Protocol driver]Connection refused. Verify Host Name and Port Number.
ERROR [HY000] [Qlik][ODBC PostgreSQL Wire Protocol driver]Connection refused. Verify Host Name and Port Number."

Regards,

Arvind

[indhu]

Can I please know if you were able to solve this? I am on the same boat. I couldn't use ODBC either