Incremental refresh

[vjnvinod]

hi,

is it possible to set an incremental refresh (i am folder as a connector, and data is in my system)

for example, I have a folder in my system, and every week I park Weekly data into it

now what happens is, Power BI refreshes all the previous data as well. is there any way it can ignore the previous week's data and do the refresh only for the latest week?

[v-easonf-msft · Accepted solution]

Hi, @vjnvinod 

You need to use a Data Source function as a base and then create you custom function that will have the correct logic to drive the Incremental refresh with the RangeStart and RangeEnd parameters that the Power BI Incremental Refresh process requires.

For more information, please check the soultion in this post:

Incremental refresh for files in a Folder or SharePoint – Power BI 

Related links:

Incremental refresh and real-time data for datasets 

Configure incremental refresh for datasets

Advanced incremental refresh with the XMLA endpoint

Best Regards,
Community Support Team _ Eason

[amitchandak]

@vjnvinod , have you already checked if these Dax append solutions can not help?

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/