cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SivaMani Senior Member
Senior Member

Amazon Redshift - ODBC Error while connecting to Incora

Hi,

 

I'm trying to connect Incorta in Power BI which is running in a VM on AWS. 

I tried to connect with Amazon Redshift and PostgreSQL database connector. It throws an error.

 

ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] Cannot enable SSL for the connection when connecting to a server that has not enabled SSL.

 Please assist me to resolve this issue.

1 ACCEPTED SOLUTION

Accepted Solutions
SivaMani Senior Member
Senior Member

Re: Amazon Redshift - ODBC Error while connecting to Incora

@v-danhe-msft ,

 

Thanks for the information.

 

I have resolved the issue with data source settings. I disabled encryption option and it works.

Here is more detail about Incorta connectivity in Power BI 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Amazon Redshift - ODBC Error while connecting to Incora

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SivaMani Senior Member
Senior Member

Re: Amazon Redshift - ODBC Error while connecting to Incora

@v-danhe-msft ,

 

Thanks for the information.

 

I have resolved the issue with data source settings. I disabled encryption option and it works.

Here is more detail about Incorta connectivity in Power BI