Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SPalmerUK
Frequent Visitor

Error connecting to PostreSQL

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,

3 REPLIES 3
SanjayPraveen
Frequent Visitor

Hey, have you fixed this issue? Is yes, how did you solve this?

 

Thanks

@amitchandak 

 

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors