Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gritman
Frequent Visitor

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

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

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:

refresh-ranges.png

Pay attention to the marked area.

 


 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

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:

refresh-ranges.png

Pay attention to the marked area.

 


 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors