Cannot connect to Amazon Redshift

[aumquaje]

Hi there,

I am trying to connect powerbi report (from NetSuite) with Amazon Redshift. I have entered credentials as ususal but it doesn't works. Any suggestions are welcome

Thank you in kindly advance 

[Anonymous]

Has anyone managed to fix this? I also have the same problem (I'm using panoply.io which builds on Redshift).

[afk]

Hi @fillipech, @varundey

Did either of you manage to fix this issue? I am also experiencing the same error message.

Thanks

afk

[fillipech]

I am also having problems with amazon redshift connection. 

I am getting this error: 

Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] SSL SYSCALL error: Software caused connection abort"

Does anyone know how to solve this error? 

Thanks!

[v-yuezhe-msft]

Hi @aumquaje,

What error message do you get? Please go to “File –> Options and Settings –> Data Source Settings”, under “Global permissions”, select any old Amazon Redshift data source connections and click on clear permission in Power BI Desktop, then connect to it and check if it is successful.

Thanks,
Lydia Zhang

[varundey]

Hi @v-yuezhe-msft

I am facing the same problem, i can connect to redshift successfully on Power BI desktop but unable to do the same online when i publish my workbook, any work around for this? Please help.

[Anonymous]

Hi , 

I am getting same error .

Error Description : 

The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.Hide details
Activity ID: 4cb30d3d-1f10-49fb-830c-45af516e3851
Request ID: ebc70f26-1143-1032-7e57-cccd8847c3df
Status code: 400
Time: Fri May 19 2017 11:38:10 GMT+0530 (India Standard Time)
Version: 13.0.1700.2199
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.

[varundey]

Hi @Anonymous

I am facing the same problem, i can connect to redshift successfully on Power BI desktop but unable to do the same online, any work around for this?

[Anonymous]

Hi , 

I also facing the same challenge

Error :

The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.Hide details
Activity ID: 4cb30d3d-1f10-49fb-830c-45af516e3851
Request ID: ebc70f26-1143-1032-7e57-cccd8847c3df
Status code: 400
Time: Fri May 19 2017 11:38:10 GMT+0530 (India Standard Time)
Version: 13.0.1700.2199
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net