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 ...
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!
v-kelly-msft's avatar
v-kelly-msft
Community Support
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!