Amazon Redshift - ODBC Error while connecting to Incora

I had the same problem when trying to connect Redshift and Qlik Sense of Power BI. The cause was that I had not created a VPC Security Group that allows traffic between AWS and them. 

Here is a step-by-step guide to create a new VPC Security Group for your Redshift Cluster. I had the same problem when adding a new Amazon Redshift ODBC Data Source on the Data Source Administrator (Win 64 bit) and also when trying to connect Amazon Redshift to Qlik Sense and Power BI. (Pictures below)

Step 1: Find you Redshift Cluster in the AWS Console and click on the link on the right side of the VPC security groups.

Step 2: A new EC2 dashboard opens. Click on the "Create Security Group" button.

Step 3: Enter a name for your security group (and memorize it), then create a new inbound rule that allows traffic to your connection (you can also allow all traffic if you know what you are doing).

Step 4: Select your new security group, in the Redshift Cluster Dashboard, by selecting the "Cluster" drop-down menu, click on "Modify Cluster" and select the newly created VPC security group in the list.

Step 1:

Step 2:

Step 3:

Step 4:

Hi SivaMani ,

What version of Power BI Desktop do you use? Please update your Power BI Desktop to latest version( Version: 2.67.5404.581 64-bit (March 2019)).

In addition, do you configure SSL for the Amazon Redshift? If so, ensure that the SSL protocol version is lower than TLS 1.2.

Regards,

Daniel He

Hi SivaMani , v-danhe-msft , jeppoo12 

Same issue I am facing but there is no option of Disable encryption for that particular ODBC connection

What steps I am missing?

Waiting for the response .

Thanks,