Forum Discussion
suganya_r
3 years agoFrequent Visitor
SAP hana Direct query with transformation data
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
suganya_r , Direct query has few limitations.
Refer if these can help
https://learn.microsoft.com/en-us/power-query/connectors/sap-hana/overview
1 Reply
- amitchandak
Super User
suganya_r , Direct query has few limitations.
Refer if these can help
https://learn.microsoft.com/en-us/power-query/connectors/sap-hana/overview