Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Unable to Connect to Amazon Redshift From ODBC




I am trying to Connect to Amazon Redshift From ODBC.







The error shows me like below,


We encountered an error while trying to connect


Details: "ODBC: ERROR [08S01] [Amazon][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not translate host name "your_Redshift_server" to address: Unknown host


Could someone please help me with how to connect to Redshift From ODBC.


Thanks in Advance

Regular Visitor

I have the same issue.  I have put in a ticket to Microsoft.  Do you still have this issue or did you solve it?

Community Support
Community Support

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:



Best Regards,



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

Not applicable

FIrst of all thanks for the reply !

I have searched and followed up the steps described in simillar tickets with no success whatsoever. There are currently no other connections available in my global settings since i've removed anything else related to Amazon Redshift.

As for the first 2 bullet points i made sure that everything is ok.

That's why i'm confused about this issue.... 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors