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.
Hi meyerovb ,
Did you install both 32bit and 64bit odbc driver for Redshift on the server that hold the gateway? It could be a permission issue in Amazon Redshift based on your error message in your original post. You may need to check forums that specialize in RedShift.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
