Amazon Redshift Connectivity Error

himyyaa · ‎10-08-2018

Hi Experts,

I am new on connecting Amazon Redshift to Power BI. Please look at the following error. What kind of prerequisite configurations should I do on Redshift before connecting the same to Power BI?

Error:

ODBC: Error [08s01 Could not connect to server: Connection timed out.

Is the server running on host and accepting TCP/IP connection on port 5439?

v-lili6-msft · ‎10-09-2018

hi, @himyyaa

Attempt to connect once then go to File==>Options and Setting ==>Data Source Settings select the Redshift connectionthen click Edit Permissions Change uncheck the encryption and change the privacy level to Public.

and it could be a network issue. Here is the similar thread for your reference.

and here is video shows you step-by-step how to configure the Simba Redshift ODBC driver, then connect to Amazon Redshift using Microsoft PowerBI Desktop and create a simple visualization.

https://www.simba.com/webinar/connecting-power-bi-to-redshift/

Best Regards,

Lin

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