Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When connecting to a PostgresSQL database, I get the following error:
Details: "An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond'"
Here are the values I put in the connector widget:
Server: acton1-act-8765.aivencloud.com
Database: defaultdb
Here are the connection details from my server:
Database Name: defaultdb
Host: acton1-act-8765.aivencloud.com
Port: 18963
User: avnadmin
What am I doing wrong here?
Thank you and have a great day!
Solved! Go to Solution.
@Anonymous , Make sure you have not missed any step, including import of certificate
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/
@Anonymous , Make sure you have not missed any step, including import of certificate
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/
@amitchandak - thank you! The ODBC connector solved this for me in your post. Much appreciated.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |