Schedule Refresh Keeps Failing: An error occurred while processing the data in the dataset

[MichealCloud]

Schedule refresh keeps failing on powerBi service. 
Please help! I am working with a postgres database and I have unchecked the encrypted connection options. However the error persists.


Here are the errors:

Data source error: The PostgreSQL source doesn't support encrypted connections. (Source at ..................). The exception was raised by the IDbCommand interface. Table: onboarding_data.
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: cc86847d-3137-4fef-9a24-47d741815f76
Request ID: cad99b0d-9c5b-dd58-2151-28ed022fb840
Time: 2023-04-12 17:41:35Z


A test report - same database
Activity ID: cc86847d-3137-4fef-9a24-47d741815f76
Request ID: 30695fc7-cdc9-84e2-bb5c-99e07bb0fe2a
Correlation ID: f98222c9-08b6-77f2-2382-275edcb8c26f
Time: Wed Apr 12 2023 10:24:02 GMT-0700 (Pacific Daylight Time)
Service version: 13.0.20442.62
Client version: 2304.1.13250-train
Cluster URI: https://wabi-west-europe-b-primary-redirect.analysis.windows.net/

[GilbertQ]

Hi @MichealCloud 

From the error it is indicating that the PostGreSQL is looking for and expecting the connection to be encrypted maybe you need to add it back in?

[MichealCloud]

Thanks GilberQ. I have added it back in and the error still persist. What could be wrong? Could it be that the connection requires an ssl?

[waleb]

pls, were you able to solve the error, I am encountering the same error too. And I am stuck