Forum Discussion
Solved
ODBC: ERROR [42000] [SAP AG][LIBODBCHDC DLL][HDBODBC] Syntax error or access violation
Hello, I am unable to connect to HANA using DirectQuery. it gives me following error message: ODBC: ERROR [42000] [SAP AG][LIBODBCHDC DLL][HDBODBC] Syntax error or access violation;257 sql synta...
Hi v-jiascu-msft, Thank you for your response.
I tried that but it didnt work out, so I created a function of the HANA query and have called the same function in the PowerQuery. It works flawlessly now.
I was able to solve the error by marking EnableFolding=False
Go to Source --> Under PowerBI native query, mark EnableFolding=False:
Hope this helps.