Forum Discussion
Unable to connect redshift latebinding views with power bi
pkumar0212,
How do you create the view? Based on my reserach, if you create view using "WITH NO SCHEMA BINDING", the columns will not be listed by clients. There is a similar thread for your reference.
In your scenario, I would recommend you create a ODBC connection for redshift following the guide in the blog, then write SQL statement in Power BI Desktop to connect to the view and check if you can import data.
Regards,
Lydia
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.
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.
pkumar0212,
Have you add SQL statement as shown in the following screenshot?
Regards,
Lydia
