I am getting time out error

Hi Anonymous 

Thank you for reaching out regarding the timeout error when connecting Power BI to Amazon Redshift via ODBC. This issue typically arises because Power BI is unable to establish a TCP connection to the Redshift cluster on port 5439.

Please follow these troubleshooting steps:

Test Connectivity: Run the command :
Test-NetConnection <redshift-cluster-endpoint> -Port 5439
From your system. If the test fails, this indicates a network or firewall issue.

Review AWS Security Groups: Go to your Redshift cluster’s VPC Security Groups and ensure inbound rules allow TCP traffic on port 5439 from your local machine’s IP (for Power BI Desktop) and Power BI service IP ranges (for cloud refresh).

Check VPC and NACL Settings: Verify that the Redshift cluster’s subnet has appropriate routing and NACL rules for inbound and outbound traffic on port 5439.

Update ODBC Driver: Install the latest Amazon Redshift ODBC driver and confirm that your Power BI connection string is accurate.

Increase Connection Timeout: In Power BI’s Data Source Advanced options, set the Connection Timeout to at least 300 seconds.

Validate Credentials: Test your Redshift credentials in SQL Workbench/J or DBeaver. If they work there but not in Power BI, review your Power BI ODBC configuration.

This error is most often due to AWS Security Group or firewall rules blocking the connection. After following the steps above, Power BI should be able to connect successfully.

Please let us know if you continue to experience issues. We are here to help.

Best Regards,
Tejaswi