Incremental Refresh with URL

[gritman]

Hello all,

I'm trying to use the incrememtal refresh and hope someone can advise me please.

I query data using a URL like:  server/path&fromDate=01-01-2020&toDate=-1BD (i.e. return data from Jan 1st to the previous Business Day).

Currently when I refresh it data is returned for everyday back to Jan 1st.

I would like to use the incremental refresh to return data for -1BD only (i.e. the previous business day) and append to previous 8 months of data.

I've setup the incremental refresh as per the instructions Microsoft have provided then changed the query to be server/path&fromDate=-1BD&toDate=-1BD.  However that wiped out the other 8months of data and only 1BD is available.

Does anyone have any suggestions on how I can keep the existing 8months of data and then switch over to load incrementally from now on please?

Many thanks

[v-kelly-msft · Accepted solution]

Hi  @gritman ,

First you should set a "RangeStart " and "RangeEnd",and make a setting such as below:

#"Filtered Rows" = Table.SelectRows(dbo_Fact, each [OrderDate] >= RangeStart and [OrderDate] < RangeEnd) 

Then set the refresh as below:

Pay attention to the marked area.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@gritman , can share the screenshot on incremental setup

refer for Incremental Load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/