Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.