Forum Discussion

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
7 years ago
Solved

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 [08...
General Comment
Need Help
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
7 years ago

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