cancel
Showing results for 
Search instead for 
Did you mean: 

PostgreSQL error: unsupported startup parameter

Hi all,

 

when trying out Power BI for the first time and attempting to connect to a PostgreSQL 12.7 database using ssl I encountered the following error, for which I can find no explanation / reference. Note that I have installed the certificate for the db server into my trusted certificates and am not running into any issues there (anymore).

 

The error message is: "PostgreSQL: 08P01: unsupported startup parameter: ssl_renegotiation_limit"

 

Apparently, ssl_renegotiation_limit is a deprecated connection parameter which is not supported anymore in decently recent PostgreSQL versions. It appears that the Power BI client is trying to use it for some reason.

 

I am using Power BI Version 2.96.701.0 64-bit (August 2021) on a Microsoft Surface 4.

Status: New
Comments
v-yingjl
Community Support

Hi @lukasstreitb24 ,

Could not reproduce it in my side as far as my test.

You can refer this simliar issue:

https://community.powerbi.com/t5/Desktop/Connector-Postgre-SQL-DATABASE/m-p/195104 

 

In addition, when you connect to PostgresSQL in Power BI Desktop, you can use Fiddler to track more information about this issue.

 

Best Regards,
Community Support Team _ Yingjie Li

lukasstreitb24
Regular Visitor

Hi @v-yingjl ,

 

thanks for getting back to me so soon.

 

The thread you referred to appears to be from a time when we had to install Npgsql ourselves to get a PostgreSQL connection going in PowerBI. Today, this ships out of the box so this feels different to me. Is there any way to check, which software Power BI is using "under the hood" to connect to PostgreSQL? Maybe something went wrong there and Power BI is using something outdated?

 

I installed Fiddler and tried to capture communication between Power BI and the database but only had a number of calls to services.visualstudio.com show up. Any advice on how to track the database traffic?

 

Thanks and best regards
Lukas

v-yingjl
Community Support

Hi @lukasstreitb24 ,

I have found that this parameter had been deprecated in 9.4 version of PostgresSQL DB.

 

"Is there any way to check, which software Power BI is using "under the hood" to connect to PostgreSQL? Maybe something went wrong there and Power BI is using something outdated?"

Power BI uses built-in connetor as your mentioned to connect to PostgresSQL directly. Since I could not reproduce it in my side and it works fine in my side(I have tested 11, 12, 13 versions of PostgresSQL)so not certain whether there is some issue with this connector.

 

If this connector not works, you can try different ways to connect to PostgresSQL DB, refer this article:

PostgreSQL To Power BI: 3 Best Ways To Connect 

 

Best Regards,
Community Support Team _ Yingjie Li

lukasstreitb24
Regular Visitor

Hi @v-yingjl ,

 

thanks again for the quick response.

 

Yes, I also found that this parameter has long since been deprecated but I was not able to figure out which party is trying to use it. After internal debugging it appears that this issue is coupled with DigitalOcean's PgBouncer pooling. I attempted connecting directly to the database, skipping the pool, and this did indeed work out.

 

For an initial proof of concept with Power BI, this suffices. If we're going forward with an overall rollout, we will still need a fix for this. To my understanding, the issue does lie with DigitalOcean though.

 

Best

Lukas