HANA Import and DirectQuery ODBC Error

[mrkuk]

Hello, after updating to latest Power BI version when adding a SAP HANA datasource there is a ODBC Error when browsing cubes in Navigator window. Making it impossible to add a new HANA datasource.

This occures when trying to use Import method.

ODBC: ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "MDX": line 1 col 1 (at pos 1)

Simmilary if I connect with DirectQuery with "Threat SAP HANA as a relational source " unchecked  I get same error

If "Threat SAP HANA as a relational source " is checked im able to add selected datasource.

[rudra_deep]

Hello @mrkuk, I was facing the same error while connecting hana using DirectQuery.

So, I created a FUNCTION of the HANA query and have called the same function in the PowerQuery with a simple select statement. You can try to do that, it worked for me.

[gautamp]

Anyone able to resolve this error? I am also getting this error when refreshing dataset via Gateway but able to refresh using Power BI Desktop. My report is also connected to Sap HANA DB. Pls help.

[v-shex-msft]

HI @mrkuk,

Can you please share more detailed information about your query? It seems like a common syntax error caused by odbc query.

Regards,

Xiaoxin Sheng

[sdittakavi]

We have the same issue. Can somebody from Microsoft look into it and let us know, what is the resolution?

[sdittakavi]

We have the same issue. I appreciate to let us know, if anybody has a solution for this?

[jontew]

We have the same issue.