I am trying to get scheduled refresh in PBI Service from a PostgreSql database on Amazon AWS but I get the message below. (This all works from PBI Desktop absolutely fine.)
Unable to update this data source’s credentials.
Unable to connect to the data source.
Game Pi: 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.
at Npgsql.Tls.TlsClientStream.SendAlertFatal(AlertDescription description, String message)
at Npgsql.Tls.TlsClientStream.ParseCertificateMessage(Byte buf, Int32& pos)
— End of stack trace from previous location where exception was thrown —