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

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 no...