Forum Discussion
Amazon Redshift Connectivity Error
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?
1 Reply
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
