cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aumquaje Frequent Visitor
Frequent Visitor

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 

8 REPLIES 8
Moderator v-yuezhe-msft
Moderator

Re: Cannot connect to Amazon Redshift

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
shubhu7 Frequent Visitor
Frequent Visitor

Re: Cannot connect to Amazon Redshift

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

 

shubhu7 Frequent Visitor
Frequent Visitor

Re: Cannot connect to Amazon Redshift

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 Frequent Visitor
Frequent Visitor

Re: Cannot connect to Amazon Redshift

Hi @shubhu7

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 Frequent Visitor
Frequent Visitor

Re: Cannot connect to Amazon Redshift

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.

fillipech Frequent Visitor
Frequent Visitor

Re: Cannot connect to Amazon Redshift

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 Regular Visitor
Regular Visitor

Re: Cannot connect to Amazon Redshift

Hi @fillipech@varundey

 

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

 

Thanks

afk

Lasselakan Regular Visitor
Regular Visitor

Re: Cannot connect to Amazon Redshift

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

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 121 members 1,508 guests
Please welcome our newest community members: