Unable to connect to Amazon Redshift via Power BI with VPN and dedicated IP

[Yasmina_KA]

Hi everyone,

I am working on a remote project for a client who requires a fixed IP address. I have a VPN with a dedicated IP address that I have shared with the client to allow me to connect to Amazon Redshift via Power BI.

However, I am unable to connect and I am receiving the following error message:

Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] timeout expired "

The client has confirmed that I am on the whitelist and that I have the necessary permissions, so it seems like the issue is not on their end.

I have never worked with Amazon Redshift before, so I am not sure if I have made any configuration errors. If I cannot find a solution, I will not be able to complete this project, which would be a huge setback for me.

I would really appreciate any help or suggestions you can provide.

Thank you in advance.

[Syndicate_Admin]

Hello! Were you able to fix it?

[Anonymous]

Hi @Yasmina_KA ,

Based on the error message you have provided, it appears that you are experiencing a timeout error, which can be affected by a number of factors. Let us address this issue step-by-step to help you move forward with your project:

1. The VPN may affect connectivity due to routing or security policies. Please ensure that there are no restrictions that may affect Amazon Redshift connectivity.
2. Since you are new to Amazon Redshift, make sure that the connectivity settings in Power BI are configured correctly:
   1. Navigate to Power Query in Power BI and select Get Data.
   2. Select Amazon Redshift from the list of data sources.
   3. Enter the Amazon Redshift server information and authentication credentials as required.
   If you would like more information, please visit the following link:
   Set up your Amazon Redshift connection - Microsoft Fabric | Microsoft Learn
3. Test the connection to Amazon Redshift without a VPN to troubleshoot any VPN-related issues. If the connection succeeds without a VPN, the problem may be with the VPN configuration or its interaction with the network.
   
   

Best Regards,

Ada Wang

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