Redshift connector error: The server name must end with .redshift.amazonaws.com

[LeonardoAlves]

I am currently trying to connect PowerBI to a Redshift, and I use a DNS that points to my default Redshift hostname. However, there is a PowerBI validation rule that only accepts hostnames that do not have the following string in their composition: ".redshift.amazonaws.com".

What should I do given that my DNS does not have the string above and I am getting the following error: "We encountered an error while trying to connect. Details: "The server name must end with .redshift.amazonaws.com"?

[Anonymous]

Hi @LeonardoAlves , hello GilbertQ , thank you for your prompt reply!

Is there any progress on this issue?

If you find GilbertQ's answer is helpful to you, please remember to accept it.

It will help others who meet the similar question in this forum.

If you have any further related issues, please feel free to reply!

[GilbertQ]

Hi @LeonardoAlves 

It would need to use the valid Redshift naming convention from AWS in order to connect successfully.

Power Query Amazon Redshift connector - Power Query | Microsoft Learn