Edit data source based on date

[barbforsman]

I have just come from Summit 17 where I learned you can limit the data source when you originally connect to it based on the date, e.g. only pull in records created after 12/31/2015.  

I wish I'd learned this 3 months ago, but unfortunately I have pulled in our entire salesorders table from Dynamics 365 online.  Is it too late, or is there a way to edit the query so the older records (pre-2016) get excluded?

Where & how would I do this?

Many thanks in advance!!

[v-shex-msft · Accepted solution]

Hi @barbforsman,

I think you can take a look at power query dynamic date filter, it may suitable for your requirement.

Using dynamic parameter values in Power Query Queries

Best way to dynamically filter date table in Power Query

Regards,

Xiaoxin Sheng