Forum Discussion
PowerBI connection pool error Postgres
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.
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!
4 Replies
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!
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!
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.
Understood, I appreciate the alternative.
