PowerBI connection pool error Postgres

[mmorley0395]

Hi, I'm trying to connect to my database using BI. I can connect fine straight to the DB, but when using my connection pool, I cannot connect. This is because PowerBI is sending a 'ssl_renegotiation_limit' parameter, which has been depricated for several versions, and my connection pool (PGBouncer) doesn't accept that ancient parameter. My database is a managed DB so I cannot alter the PGBouncer config file to ignore that parameter. This is really fully on Microsoft for sending a parameter that hasn't been around for 7 major versions in Postgres. 

[wardy912]

Apologies, it's not a solution, but offers an alternative to a deprecated product. I don't believe there is a solution that will enable it for you.

[mmorley0395]

Understood, I appreciate the alternative. 

[wardy912 · Accepted solution]

Hi @mmorley0395 

 Please see this previous post, it contains an accepted solution

Solved: Connection error "PostgreSQL: 08P01: unsupported s... - Microsoft Fabric Community

I hope this helps, please give a thumbs up and mark as solved if it does (even though it isn't my solution 😉), thanks!

[mmorley0395]

Sorry- this doesn't address my concern; the solution in that link is to use ODBC. I'm not asking about ODBC, I'm asking about PowerBI's native Postgres connector, and asking why Microsoft is still sending this deprecated parameter in their native driver. Thanks!