Power Query Dynamic Date FIlter

[Suny_13]

i have monthly excel file data of around 3 years. my new data keep on adding every month. So when my new data come and i refresh the model whole data got refresh. i want to keep the historic year data stagnant and new year data keep on refresh when i press refresh in power bi premium. my Fiscal yesr starts from july

[pratyashasamal]

Hi @Suny_13 ,
Please mark this as the solution if it was helpful for you .
Thanks.

[pratyashasamal · Accepted solution]

Hi ,
To keep the historical data and get new fresh data added to the dataset please try incremental refresh .
These are few good blog that could follow to implement incremental refresh :

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-

overview

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only...

https://www.thepoweruser.com/2020/01/19/incremental-refresh-for-files-in-a-folder-or-sharepoint-powe...
Thanks .

[Suny_13]

Thanks but is there any other way of doing that...i.e inside the power query