Unable to Connect to Amazon Redshift From ODBC

Hi Anonymous ,

There are some points to you can considerate:

1.Make sure type the correct Amazon Redshift server and database name, also type the correct hostname.

2.Please check if the network issues(such as IP issues).

3.This maybe a permission/authentication error. Please go to “File –> Options and Settings –> Data Source Settings”, under “Global permissions”, select any old Amazon Redshift data source connections and click on clear permission in Power BI Desktop, then connect to it and check if it is successful.

You can refer to the similar issues: https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-refusal-failure-issues.html

                                                               https://stackoverflow.com/questions/41854006/getting-an-error-trying-to-connect-to-amazon-rds-with-postgresql

https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/106

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.