Forum Discussion

pkumar0212's avatar
pkumar0212
New Member
8 years ago

Unable to connect redshift latebinding views with power bi

Hii Team,  Hope your  are doing great, Surprisingly I am unable to connect redshift latebinding views in power BI as mentioned below. Can some body help me in connecting with the same.?   Error M...
General Comment
Show and Tell
pkumar0212's avatar
pkumar0212
New Member
8 years ago

Hii Team,

 

I tried to connect with ODBC but still getting the below error message:

 

Details: "ODBC: ERROR [HY000] [Amazon][RedShift ODBC] (10) Error occurred while trying to connect: FATAL: password authentication failed for user "pradeep"
FATAL: password authentication failed for user "pradeep"

ERROR [HY000] [Amazon][RedShift ODBC] (10) Error occurred while trying to connect: FATAL: password authentication failed for user "pradeep"
FATAL: password authentication failed for user "pradeep"

"

Can u check & suggest the best way to get off it.

pkumar0212's avatar
pkumar0212
New Member
8 years ago

Hii Team 

 

Surpisingly after connecting the Power BI to redshift through ODBC connector still I am getting the same error message. Please check & suggest the reliable solution as i am struggling with the same for last 15 Days. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    pkumar0212,

    Have you add SQL statement as shown in the following screenshot?


    Regards,
    Lydia