Stop power query from loading to excel sheet

Question

I'm now studying Excel Power Query. I have a spreadsheet filled with dates and sales from previous transactions. I make a new spreadsheet every month to examine sales information. I have a "setup" sheet for each monthly spreadsheet where I enter the beginning and ending dates of the month as well as the names "from date" and "to date" (my months are not based on actual month start and end).

As a result, I have configured a Power Query query that chooses all of the sales data and filters it based on two empty searches from the two named dates. Although it puts these "blank ranges" into the Excel sheet, this method is effective. Is it possible to prevent this from occurring and limit Power Query to the two named date queries only?

Answer 1

You can just delete the worksheets created by PowerQuery. If you open the Queries & Connections pane from the Data ribbon, you'll see that the query should now say Connection only. Alternatively, when you first click Load To, you can choose the Only Create Connection option.

I hope this helps you.