Tabular: Error while using ODBC data source for Importing Data

  • Article

Issue

When using ODBC as a Data Source in the Table Import Wizard to add data to a Tabular Server, we are getting the following  error; however, preview shows the data correctly:

Error Message:

OLE DB or ODBC error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application; IM014.

A connection could not be made to the data source with the DataSourceID of '7300a711-299c-4367-98eb-b2e01b7e4ba5', Name of 'Custom 4'.

An error occurred while processing the partition 'DimAccount 1_e8a5233f-406a-450d-8b2e-8bf86a321d2f' in table 'DimAccount 1_e8a5233f-406a-450d-8b2e-8bf86a321d2f'.

The current operation was cancelled because another operation in the transaction failed.

Environment

SSAS Tabular Server 2012 x64

Assessment

Read more………………….Link