Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
EvertVD
Frequent 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.

EvertVD_0-1653479189992.jpeg

Does anyone know what I can do to make the option selectable?

Thanks for your reply!

Grz, Evert

 

2 REPLIES 2
DataInsights
Super User
Super User

@EvertVD,

 

Have you enabled this checkbox in Options --> DirectQuery?

 

DataInsights_0-1653524953376.png

 

 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-sap-hana 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors