I failed to connect to an Amazon Redshift cluster from my PC via network load balancer on AWS with the following error message.
"ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] server certificate for "[redshift server name]" does not match host name "[load balancer name]"
The settings on AWS are correct since I can connect to my Redshift cluster with exactly the same connection information using an DB tool, so the cause should be somewhere on Power BI side.
Kindly investigate this bug and provide me the solution.
Thanks in advance.
Hi @Eiko ,
You may resolve the issue with data source settings. disabled encryption option and it works.
Here is more detail about Incorta connectivity in Power BI
Solved: Amazon Redshift - ODBC Error while connecting to I... - Microsoft Power BI Community
Community Support Team_ Caitlyn