Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

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

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.

Refresh Schedule Error

V-lianl-msft
5 years ago
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.

3 Replies

V-lianl-msft
Community Support
5 years ago
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
  Advocate I
  5 years ago
  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
    New Member
    2 years ago
    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!

Related content