Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi,
I'm having an issue with an OBDC connection. I've created (through PBI Desktop) and published to PBI service using various flat files and an external OBDC connection to a postgres database. For my OBDC connection, I just use the following OBDC connection string:
Driver={PostgreSQL Unicode(x64)}; Server=XX.XX.XX.XX; Port=5432; Database=XXXX
The connection has worked perfectly fine for a few months until I received a connection error today.
After researching, I was just told by my one of the admins that they switched over to SSL recently for that database. With that information, I figured I would just add ";sslmode=require" to the end of the string
Driver={PostgreSQL Unicode(x64)}; Server=XX.XX.XX.XX; Port=5432; Database=XXXX;;sslmode=require;
However adding this string gives me a FATAL: connection requires a valid client certificate error message. How do I fix this issue? Any help is appreciated. Thanks!
@Anonymous , Please check and do not miss any step. Or create a dataflow on power bi service and use that as source
postgresql
https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 17 | |
| 11 |
| User | Count |
|---|---|
| 55 | |
| 53 | |
| 41 | |
| 36 | |
| 32 |