3516830 - Error "383 invalid identifier: parameterized sql view <view_name> without input arguments" in Ms. Excel or PowerBI using ODBC connection to HANA Cloud or to DataSphere

Symptom

When using a parameterized view in Excel or PowerBI using a ODBC connection to SAP HANA Cloud or SAP DataSphere, the following error occurs:

DataSource.Error: ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;383 invalid identifier: parameterized sql view <View_Name> without input arguments: line xx col xx (at pos xxx)Details: DataSourceKind=Odbc DataSourcePath=dsn=<DSN_Name> OdbcErrors=[Table]ODBC Connection (HANA Driver 2.20.22)

Whereas in Database Explorer, it is successful.

without input arguments" in Ms. Excel or PowerBI using ODBC connection to HANA Cloud or to DataSphere"> Read more...

Environment

SAP HANA Cloud
SAP DataSphere

Product

SAP HANA Cloud 1.0

Keywords

Excel, ODBC, connection, HANA Cloud, Datasphere, DSN, 383, "invalid identifier", "parameterized sql view", PowerBI , KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , DS-MD-VIW , Views , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.