PostgreSQL incremental refresh failing

[Tabaqat_Team]

I have set up a connection to a PostgreSQL database and made an incremental refresh 8 times and it fails every time and returns this message: The PostgreSQL source doesn't support encrypted connections. 

Although I've modified the Encrypted connection to Not encrypted  

[arctellion]

I am getting similar issues, with the PowerBI service. 
I have no issues within PowerBI Desktop it doesn't matter if encryption is enabled or not acess to PostgreSQL just works out of the box. 

I am running a linux server hosting my PostgreSQL, I have disabled encryption on the server, I've disabled encryption in the connection between PowerBI Desktop and the server, when it comes to trying to authenticate the user on the server there I see no options for disabling encryption: 

When the server credentials are filled into the box above accessed from the change credentials button, I get the following error:

Failed to update data source credentials: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'

Activity ID:	98ab6a06-79a1-4372-b3e1-46faa69775fb
Request ID:	6d6e518d-bce7-4357-d96c-beeb77dc605c
Status code:	400
Time:	Mon Jul 24 2023 14:14:11 GMT+0100 (British Summer Time)
Service version:	13.0.21215.53
Client version:	2307.4.14945-train
Cluster URI:	https://wabi-uk-south-redirect.analysis.windows.net/

I am getting very frustrated with the whole thing. I am not using any mission critical data or anything that's super sensitive, otherwise I'd have to figure out how to make an encrypted connection. But the PowerBI Service should just work, like the desktop client.. that's the implication from the PowerBI service help pages, it's why I chose a PostgreSQL database in the first place, I wouldn't need to have onsite gateways or other tools to make the syncing of data work, it would just work out of the box. 

Now if there is a setting that needs to be changed on my service, or somthing like that to get it to work it would be helpful to know. 

I will add, that before I went into producing actual reports that are needed, I tested it, and it worked no problems. Now 6 months later there are security certificate issues, and nothing has changed on the PostgreSQL server side, it's the same server as during testing. 

Any help would be greatly appreciated,

[v-yueyunzh-msft · Accepted solution]

Hi , @Tabaqat_Team

Based on your error situation and screenshots given, I think the root cause of the issue is that the PostgreSQL source does not support encrypted connections, and Power BI is attempting to establish an encrypted connection despite being set to "Not encrypted."

If convenient, would you like to also go to the Power BI desktop source .pbix file to edit the datasource connection to the "PostgreSQL source" is not encrypted and publish the report to the Power BI service again to configure the datasource connection again.

For the detailed process in the Power BI desktop, you may also refer to this official document link:

Power Query PostgreSQL connector - Power Query | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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