The specified DSN contains an architecture mismatch between the Driver and Application"

[Aviokc2011]

Hi All

Trying to connect to HANA with power BI

HANA ODBC is 32 bit and Power BI 64 Bit

Giving error - Details: "ODBC: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

Is there a solution for this issue ?

[v-qiuyu-msft]

Hi @Aviokc2011,

In your scenario, how did you connect to HANA database, via ODBC or SAP HANA Database data source type in Power BI Desktop?

From the error message, the issue is caused by that the 64 bit Power BI Desktop is not compatible with the 32 bit SAP HANA ODBC driver. To solve the issue, you can either install 64 bit SAP HANA ODBC driver, use 64 bit Power BI Desktop to get data. Or install 32 bit Power BI Desktop, then connect to SAP HANA database.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[DW]

Since i installed the update i am having the same issue connecting to an oracle server which ran before on PowerBI 64bit