Courses / Power Query (Get & Transform)
19. Disabling load for intermediate queries
Turning off 'Enable Load' for helper queries to avoid cluttering the workbook while keeping them available.
Power Query M (Excel)
Disabling load for intermediate queries
A workbook setting that prevents a helper query from creating its own worksheet/table while keeping the query available for other queries.
"I want helper steps without cluttering my workbook with extra tables."
Disable load (uncheck "Enable Load" or "Load To..." → uncheck) stops a query from producing a visible table in the workbook but does not remove the query from the query list or stop it being used by other queries.
"I want helper steps without cluttering my workbook with extra tables."
Disable load (uncheck "Enable Load" or "Load To..." → uncheck) stops a query from producing a visible table in the workbook but does not remove the query from the query list or stop it being used by other queries.