Forum Discussion

gritman's avatar
gritman
Frequent Visitor
6 years ago
Solved

Incremental Refresh with URL

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

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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!

2 Replies