The difference was that the connection string generated by the personal-mode gateway not only contained server and database but also the DSN name! This seemingly redundant configuration did the trick! So, to recap: when defining the datasource in Power BI service, make sure its connection string looks like: driver= server= dsn= through a standard ODBC Driver interface. Access Amazon S3 like you would a database - access Objects, Buckets, etc. However, the datasource on Power BI service uses a connection string to be set up. The Amazon S3 ODBC Driver is a powerful tool that allows you to connect with live Amazon S3 cloud storage, directly from any applications that support ODBC connectivity. we used odbc connector (get data -> odbc) to enter redshift connection details.Īs redhsift is inside a private n/w, will odbc connector work? do we need to use custom so much for hinting the answer! Actually, the DSN cannot be configured via a connection string since only a form is provided.
#Amazon redshift odbc driver 64 bit how to#
Please suggest on how to connect to AWS redhsift inside a VPC from power bi desktop tool. We followed the same steps as given above, but were not able to connect powerbi desktop to private redshift. ** Power BI report published from desktop.Īre there any specific details of your setup that you think could make it work? ** On-premise gateway set up with ODBC data source successfully connected. ** Power BI report using ODBC to successfully retrieve data from Redshift. ** Power BI on-premise gateway setup (not personal).
** Public IP with no inbound/outbound networking restrictions (this is temporary for testing!). ** System DSN successfully connected to our Redshift cluster. The trick is that the server and database names must match in the local ODBC used in Power BI desktop and the one used to configure the data source available through the gateway. In Microsoft Windows, you typically set driver options when you configure a data source name (DSN). To do this, set up the connection on your client computer or Amazon EC2 instance. Being able to handle both 32- and 64-bit architectures, the software utility allows you to create a direct connection between your applications and Amazon. Full Unicode Support - any language, any data.
#Amazon redshift odbc driver 64 bit drivers#
Thanks a lot for sharing the solution! After following all the steps, my report cannot refresh on Power BI Service (online) because it cannot find an appropriate data source in a gateway. According to Amazon Redshift provides ODBC drivers to allow third-party SQL client tools and applications to make an ODBC connection to an Amazon Redshift cluster. ODBC 3.8 compliant native protocol based drivers.
0 kommentar(er)
