issues connecting data flow to postgresql hosted on AWS

[benovic]

HI There,

we have recourring issues with a data flow.

DataSource.Error: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.
'DetailsDataSourceKind = PostgreSQL
DataSourcePath = AWS-URL-PATH.amazonaws.com;DATABASE-NAME

PowerBi complains about this since a couple of days, and It seems this cannot be solved with additional drivers or certs, since it's in a data flow and all happening online. Also why we don't need a gateway.

[v-chuncz-msft]

@benovic 

A similar issue has been reported internally. 

IcM 256988626

We cannot support connecting from Power BI Service to <random provider> using SSL, unless their Server Certificate is signed by a certificate that's in the "Trusted Root" certificate store on the servers that run the Power BI Service.

An exception is drivers that are specific to a particular vendor, such as Google Big Query, or Amazon Redshift. In these cases, the certificates are included in the driver, and they don't use the Windows Crypto APIs for this.

One other exception is for certain Azure hosted services - our servers (usually) already trust the certificates sent by those.

The other choices are to use an unencrypted connection (we disallow this, unless you're using a gateway), or to use a gateway and configure the trusted root store on it.

If you would like to create a feature request for "Trust AWS Certs in Power BI Service", then please go to Ideas (powerbi.com)