Forum Discussion
EvertVD
4 years agoFrequent Visitor
SAP Business Warehouse-applicationserver: Option DirectQuery is grayed out
Hello, I tried to create a connection to Sap BW and want to use the option DirectQuery but it is grayed out.
Does anyone know what I can do to make the option selectable?
Thanks for your reply!
Grz, Evert
2 Replies
- DataInsights
Super User
Have you enabled this checkbox in Options --> DirectQuery?
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-sap-hana
- EvertVDFrequent Visitor
Hallo DataInsights,
a collegue of my is also using this connector. He has the option "Treat SAP HANA..." switched off but Direct Query is selectable for him. I understood that the option "Treat SAP HANA..." is only for query folding?
Grz, Evert