Data Gateway - dataset refresh error -The PostgreSQL source doesn't support encrypted connection

[mali_obiekan]

I have an issue,  I have a report that uses a PostgreSQL data source, after publishing the report from the Power BI desktop app
getting this error "Failed to update data source credentials: The PostgreSQL source doesn't support encrypted connections."

[v-xiaoyan-msft]

Hi @mali_obiekan ,

Do you have a gateway configured for the data source?If you are using Directquery to connect to a data source, it requires a gateway for the data source to open the report properly.

Add or remove a gateway data source 

If you don't have a gateway installed yet, see Install an on-premises data gateway to get started.

You may also refer to this thread：

Power BI connection problem with Postgresql 

Best Regards,
Community Support Team _ Caitlyn

[mali_obiekan]

Hi v-caitlyn-mstf,
Thanks for your response,

we are using Directquery to connect to azure databases for PostgreSQL data source.
we're using get data with Azure DB for PostgreSQL and add server credentials on Powe BI Desktop with Directquery with the advanced query, after publishing the report to the portal then the issue  "The PostgreSQL source doesn't support encrypted connections." appeared.