Scheduled Data Refresh Error on Postgres:The PostgreSQL source doesn't support encrypted connections

[Anonymous]

Hi all, 

This is my configuration:

1) Power Bi Desktop on my PC

2) Postgressql DB on company server

3) Published report on powerbi online

I created some reports and published them on powerbi online. Everythings fine.

I want to automatically schedule the data refresh but I have this error

The PostgreSQL source doesn't support encrypted connections

I'm trying different solution but nothing helped.

Can someone help me to find a way to solve?

Regards.

[V-lianl-msft · Accepted solution]

Hi @Anonymous

Refer to this blog:

https://medium.com/niftit-sharepoint-blog/installing-power-bi-data-gateway-for-refresh-of-postgresql-database-6a58e14e59e3 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MoorsTech]

Hi @V-lianl-msft,

shouldn't the Power BI service  be able to connect to PostgreSQL without a gateway these days?
This table says so: https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

Cheers
Lukas

[TomaszT]

@MoorsTech did you managed to do it without gateway? 

We miss something or MS is having obvious inconsistency between documentation and reality for at least 3 years!