Forum Discussion

vmbruno's avatar
vmbruno
Advocate I
10 years ago

Connect to PostgreSQL

Hi everybody!   I'm trying to get data from a PostgreSQL database but it doesn't seem to work. I think I miss some of the components that need to be installed. When trying to setup a new connection...
Need Help
Tutorial Requests
vmbruno's avatar
vmbruno
Advocate I
10 years ago

Hi Sebastian,

 

Thanlk you so much for your reply! I went to that page and ran that .exe file. I think something has definitely improved since PowerBI no longer tells me of the missing files. However I still can't connect to the database. This is the error that I'm getting after I type in the server and database address :

 

"Unable to Connect

We encountered an error while trying to connect.

Details: "PostgreSQL: Failed to establish a connection to 'ec2-54-217-246-62.eu-west-1.compute.amazonaws.com'.""

 

Do you have any idea why this might be happening? In Excel I don't even get the PostgreSQL option when adding a new source. Could this be from the setup I installed was not fully compatible with my system/version?

 

Best,

Bruno :smileyhappy:

 

 

felipetancredo's avatar
felipetancredo
New Member
10 years ago

I'm getting the same problem:

 

PostgreSQL: Failed to establish a connection to 'xxxxxxxxxxx.us-west-2.rds.amazonaws.com'.

 

My Personal Gateway is installed on AWS west-2 region.

 

Any ideas?