dataflow - connect to Postgres SQL in Azure with SSL enabled

[Anonymous]

When connecting to an Azure Postgres instance in dataflow, I got the following error msg: 

After troubleshooting, I found the issue came from that Azure Postgres had SSL enabled. 

How can I connect to an SSL-enabled Postgres instance in dataflow? 

Thanks,
Jeremy

[Anonymous]

Hi  @Anonymous ,

Have you test with postgres sql who not enabled SSL ? According to error message, it seems like encrypt credentials not valid.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin, 

yes, we have tested with SSL disabled and it works. We used the same credential. Therefore, I am certain that the SSL setting causes the issue. 

However, we must have SSL enabled for security reason. 

We will test using ODBC connector today. But do prefer to use native Postgres connector. 

Thanks,
Jeremy

[Anonymous]

HI @Anonymous ,

AFAIK, power bi not support to get data from data sources who has multiple encrypt settings. Maybe you can submit an idea for add support with SSL.

Regards,
Xiaoxin Sheng