PowerQuery pull back selected date

[mahmed1]

Hi All

I have set up powerQuery connection to pull back data from a database - At the minute it pulls back everything

Is it possible to only pull back data from a start date and end date in excel?

so say im A1 i have startdate and A2 i have enddate - Can i only pull back that data so im not pulling more data than needed?

And also in VBA - im refreshing all the powerQuery connections...I recorded a macro and the macro code first selects the sheet and then uses Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False

I tried to not use the select method and just refresh it by using the following thisworkbook.connections(“tblQuery”).refresh but that fails
how can i avoid using select?

 

[sandy666]

(It was so much easier with older version imo)

older version of what?

there are blue tables
- small is a source of range of dates
- bigger is "your" data (can be directly loaded from database into Power Query)
check in Name Manager what the names they have

1) A1: Enter Start Date NO
2) B1: Enter End Date NO
3) Generate a list of dates in Excel between those 2 dates (say this table is called DateList) NO
4) Get data from database NO
5 Get data from Excel NO
6) Join date table to database date NO

Now how do i do a left outer join in PowerQuery?

with Merge Queries you will see that choice

I suggest to read this carefully

Power Query documentation - Power Query

Power Query is used to filter, combine, and mash up data from one or more supported data sources.

docs.microsoft.com

sorry but no pain, no gain