Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi all,
I am trying to connect to a PostgreSQL database hosted by AWS - I enter all the correct server/port/database details and username/password, but constantly get the following error message back:
"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'"
I am using Power BI desktop, Version: 2.99.862.0 64-bit (November 2021).
I can connect to the database in question via DBeaver, HeidiSQL or PGAdmin 4 so am unsure as to why this is happening?
I have looked over previous posts regarding connection issues but can't spot any that fit this specific issue.
Separate issue: previously I have connected via a remote desktop link to a different environment, but now when I try to log into Power BI there I can enter my username/email but the enter password window is blank?
Thanks,
Hey, have you fixed this issue? Is yes, how did you solve this?
Thanks
@Anonymous , Please makse sure you not missing driver, certificate or any other step
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/
https://niftit.com/connecting-power-bi-to-postgresql/
I have tried these steps previously and I still get the same error.
The database is hosted by a 3rd party, in order to access the database via PG Admin or DBeaver we have to use a different server string (port and database remain the same).
If I use this different string, I get the below:
"An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"
This implies (to me) that I am missing a certificate in order to confirm that my connection is legitimate?
Thanks fo the earlier response.
User | Count |
---|---|
80 | |
77 | |
64 | |
48 | |
45 |
User | Count |
---|---|
103 | |
45 | |
39 | |
39 | |
36 |