Stop power query from loading to excel sheet

0 votes
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?
Dec 17, 2022 in Others by Kithuzzz
• 38,010 points
4,260 views

1 answer to this question.

0 votes
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.
answered Dec 17, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

Unable to load 'minutes' correctly from CSV into in Power Query / Pivot

Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...READ MORE

answered Feb 3, 2023 in Others by narikkadan
• 63,700 points
230 views
0 votes
1 answer

Excel Power Query Moves old Data to the right

Just empty the page and then add ...READ MORE

answered Feb 16, 2023 in Others by Kithuzzz
• 38,010 points
255 views
0 votes
1 answer

Add column from another table using excel power query

Use a left outer join to combine ...READ MORE

answered Feb 24, 2023 in Others by narikkadan
• 63,700 points
923 views
0 votes
1 answer

How do I stop python from appending data to the same row in excel?

There is no indication in your code ...READ MORE

answered Mar 25, 2023 in Others by narikkadan
• 63,700 points
356 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
3,948 views
0 votes
1 answer

Power Query : http POST request with form data

Try using Uri.BuildQueryString and Json.Document. let ...READ MORE

answered Dec 12, 2018 in Power BI by Upasana
• 8,620 points
8,427 views
0 votes
1 answer

Power Query : Adding Columns and Multiple files

The following call, FirstRowAsHeader = Table.PromoteHeaders(TableWithoutHeader) shall replace the ...READ MORE

answered Feb 14, 2019 in Power BI by Upasana
• 8,620 points
1,503 views
0 votes
1 answer

Power Query : making HTTP POST request with form data

Try Using Uri.BuildQueryString and Json.Document let ...READ MORE

answered Feb 14, 2019 in Power BI by Upasana
• 8,620 points
5,784 views
0 votes
1 answer

Stop Excel from automatically converting certain text values to dates

I've discovered that getting the desired result ...READ MORE

answered Dec 29, 2022 in Others by narikkadan
• 63,700 points
371 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP