6.11 Close & Apply and Enable Load
- Home › Close & Apply runs all queries and loads the results into the model.
- Right-click a helper query (e.g. a staging query used only for merges) and untick Enable load. It will still run, but it will not appear as a table in the model – keeping the model clean and small.
Practice task
Aata he bagha: create a staging query for Blinkit orders with Enable load turned off, reference it to build the final Orders query, and check the result in View › Query Dependencies.
Ravindra Bagale's Tip
Friends, many students load helper and staging queries into the model, which makes the Data pane messy and the model bigger. Right-click helper queries and untick Enable load. Also untick Include in report refresh for static lookup tables that never change. It's very simple – just make it a habit.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students helper आणि staging queries model मध्ये load करतात, त्यामुळे Data pane गोंधळलेला दिसतो आणि model मोठं होतं. Helper queries वर right-click करून Enable load untick करा. कधीच न बदलणाऱ्या static lookup tables साठी Include in report refresh पण untick करा. एकदम simple आहे, फक्त सवय लावून घ्या.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students helper और staging queries को model में load कर देते हैं, जिससे Data pane बिखरा दिखता है और model बड़ा हो जाता है. Helper queries पर right-click करके Enable load untick करो. कभी न बदलने वाली static lookup tables के लिए Include in report refresh भी untick करो. बहुत आसान है, बस आदत बना लो.
Thodkyaat sangaycha tar (quick recap)
Power Query source badalat nahi, fakt steps record karto; steps la changli nava dya; type detection nehmi check kara; aani Reference vs Duplicate madhla farak lakshat theva. Aata pudhe jaauya – khara data cleaning suru!