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
• 28,700 points
66 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
• 53,160 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 3 days ago in Others by narikkadan
• 53,160 points
18 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 22,940 points
681 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 22,940 points
528 views
0 votes
0 answers

Download Excel sheet from .NET Core 3.1 Web API with jQuery Ajax client

I am trying to download an Excel ...READ MORE

Feb 10, 2022 in Others by Edureka
• 13,630 points
478 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,010 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
7,439 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,098 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
4,806 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
• 53,160 points
52 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