Using Source = SapHana.Database(ServerName ,Query ),

[ozmike]

Hi does anyone know how to select from using this method?

SapHana.Database(ServerName ,Query ),

[dexterz]

you should create sap hana info-view

[ozmike]

Sorry don't have write access to SAP-HANA..

Thats why I need this method..

[ozmike · Accepted solution]

let
Source = SapHana.Database("myhanaserver:12345",
[Query="select ""mycolumn"" from ""ZXXX.ZXXX_REP.bp::BPAddresses2"""])
in
Source

 Note the above syntax will work..

If you get this error

DataSource.Error: ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;260 invalid column name: Business Partner: line 1 col 8 (at pos 7)
Details:
    DataSourceKind=SapHana
    DataSourcePath=xx:123
    OdbcErrors=Table

 Note SAP hana internal names don't have spaces so

""my column"" should be ""mycolumn""

This is because Power Bi displays the SAP HANA column "label" not the column name, so you may need to ask a SAP hana developer the actual column name its not always a simple case of removing spaces.

Does anyone know if you can select form the system catalogs to get the real column names? and what is the HANA SQL?