Connect Power BI to Greenplum error “unrecognized configuration parameter ssl_renegotiation_limit”

[Lite]

I've encountered "unrecognized configuration parameter ssl_renegotiation_limit" when im trying to connect Power BI to Greenplum DB (PostgreSQL 8.2.15 and this GP DB using SSL) and I've already add my GP DB SSL certificate to my machine.

in the online documentation suggest to set ssl_renegotiation_limit parameter in postgresql.conf to '0' to avoid this kind of error, but the problem is I can't find any ssl_renegotiation_limit parameter in my postgresql.conf file.

is there any other way to connect Power BI to Greenplum DB to avoid above error?

[tanheluk]

You need to go to the Data Source Setttings... Edit Perimissions... and uncheck Encrypt connections. This issue may not be persistent in later versions of Power BI desktop.

[v-easonf-msft]

Hi , @Lite 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or your reply as Answered to close this thread?

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi , @Lite 

Have you considered that the current version of greenplum and powerbi are incompatible?

Take a try to update and move to the lastest version  of Greenplum.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Refer:

https://stackoverflow.com/questions/60314805/connect-power-bi-to-greenplum-error-unrecognized-config...