Forum Discussion

rmandadapu's avatar
rmandadapu
New Member
9 years ago

Unable to Connect to Amazon RedShift

This error shows me like below,   We encountered an error while trying to connect   Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLSta...
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi rmandadapu,

 

Amazon Redshift connector should be generally available since 2017-June release. See Amazon Redshift connector is now generally available

 

Based on my research, the could be a network issues. Here is the similar thread for your reference. :smileyhappy: 

After a few days of testing, we have found that these have been network issues for within the office - we have some serious IP issues ongoing and as a result, switching the datasource did not help. I even created a new pbix file to use MYSQL database but refresh did not go through, whereas at home, i was able to run it without a hitch. 

 

I have now resolved this by actually switching out from a desktop to a windows server on aws, and a couple of days in and the refresh runs well and takes less one third the time is used to - barring some import errors while publishing which persisted last night, i think this solution is working well 


 

Regards