GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError Received error payload from gateway service with ID 2772083: Async operation 831e08d3-9dbe-48cd-b576-7d39e8d271be is faulted with .Diagnostics.MashupDataAccessValueException: Mashup expression evaluation error. Additional error details: DM_GWPipeline_Gateway_MashupDataAccessError Error returned: ‘An error occurred during On-Premise Gateway related activity. However, when I manually try to process the model from SSMS I get the following error:įailed to save modifications to the server. I was able to load data from Redshift into a tabular model in Visual Studio and deploy the model to an Azure AS instance. I went into my ODBC Data Source Administrator (32bit).I downloaded it from the following location: Configuration of 32bit ODBC Connectionīelow are the steps to configure the 32bit ODBC Connection. NOTE: The first thing I had to do was to make sure I had installed both the 32bit & 64bit ODBC drivers for Redshift The details below should also work for other ODBC data sources too. This lead me to a few websites and the one that got me to my solution was Tabular: Error while using ODBC data source for Importing Dataīelow are the steps on how I installed, configured and got the connection and refresh working. The first issue that I encountered was the following error: OLE DB or ODBC error: The specified DSN contains an architecture mismatch between the Driver and Application AWS PROD. I am busy working with a customer and had a challenge when using Azure Analysis Services to connect to Amazon Redshift via an ODBC connection.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |