Forum Discussion

aumquaje's avatar
aumquaje
Regular Visitor
9 years ago

Cannot connect to Amazon Redshift

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 

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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's avatar
        varundey
        New Member
        9 years ago

        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?

    • varundey's avatar
      varundey
      New Member
      9 years ago

      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 when i publish my workbook, any work around for this? Please help.

  • fillipech's avatar
    fillipech
    New Member
    8 years ago

    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!

     

  • afk's avatar
    afk
    Advocate II
    8 years ago

    Hi fillipech, varundey

     

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

     

    Thanks

    afk

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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