SAP hana Direct query with transformation data

[suganya_r]

Hi,

I am using PBi desktop version connecting to SAP Hana DB. When I select the connection as Direct query I don't get the option to 'transform data'. The only option that is highlighted is to 'load' data. If I load data I don't see any option for power query and not able to select multiple Hana views. How to create a report with multiple views?

I am new to Power Bi and just started to learn.

Thanks

Suganya

[amitchandak · Accepted solution]

@suganya_r , Direct query has few limitations.

Refer if these can help

https://learn.microsoft.com/en-us/power-query/connectors/sap-hana/overview

https://www.youtube.com/watch?v=-PgRJ9vcw_E

https://www.youtube.com/watch?v=l47_u_n7XVc