Forum Discussion
Amazon Redshift connectivity issue for data flows
Hi meyerovb
What happens if you try and use an ODBC connection instead of the Amazon Redshift option and see if that works?
You can use the blog post here to show how to configure the ODBC connection: Using Azure Analysis Services to connect via an ODBC Source (Redshift) - Reporting/Analytics Made easy with FourMoo and Power BI
I'm using the website, not desktop
Tried odbc connection string, selected the on-premise gateway in the drop down, tried anonymous or same sql user login as on-prem gateway
Driver=Amazon Redshift (x64); Server=...; Database=...; Port=5439
Immediately Returns Unexpected Error
Tried x86 instead of x64, got this after like 30 seconds:
An exception occurred: The 'Driver' property with value 'Amazon Redshift (x86)' doesn't correspond to an installed ODBC driver.