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 nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi!
I can't connect my postgreSQL Database to Power BI desktop due to this error:
"Details: "An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"
I have already confirmed that my DB has public access and that I can connect from python for example, using the same credentials.
We are using Amazon RDS with PostgreSQL 17.2 in EU West, and we have SSL certification.
We also checked Solved: Connect Desktop Power BI to AWS RDS postgreSQL - Microsoft Fabric Community
where we tried using ODBC, the connection test made there seems to be OK, but it fails again when connecting ODBC to Power BI with the credentials:
Details: "ODBC: ERROR [08001] FATAL: no pg_hba.conf entry for host "{my_host}", user "{my_user}", database "{my_database}", no encryption
FATAL: password authentication failed for user "{my_user}"
"
Any feedback is appreciated, thanks!
Solved! Go to Solution.
Hi @cayetanoScala - can you pleae find the below threads solved one
Solved: Import data AWS RDS PostgreSQL --> PowerBI - Microsoft Fabric Community
Solved: Unable to connect to aws rds-postgresql - Microsoft Fabric Community
Summary:
Proud to be a Super User! | |
Hi @cayetanoScala - can you pleae find the below threads solved one
Solved: Import data AWS RDS PostgreSQL --> PowerBI - Microsoft Fabric Community
Solved: Unable to connect to aws rds-postgresql - Microsoft Fabric Community
Summary:
Proud to be a Super User! | |
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 41 | |
| 30 | |
| 24 |