Forum Discussion

jpt1228's avatar
jpt1228
Responsive Resident
6 years ago
Solved

Incremental Refresh Date Parameters

Hello - I want to get one of my data models on the incremental refresh. I have not used parameters before. From what I understand I need to go into the Query Editor and create 2 Parameters - DateStar...
Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi jpt1228 ,

     

    Answers for your questions are:

     

    1.Yes, Paratemer needs to be called RangeStart and RangeEnd.

    2.Yes,you did right.

     

    I guess you have understood how to set the Incremental Refresh,just have a try,be sure that you do it in a Premium account.

     

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

     

jpt1228's avatar
jpt1228
Responsive Resident
6 years ago

Hello v-kelly-msft  parry2k  - I have read that post. So from what I understand the field is text, but am confused why there are formulas in the examples.

 

My 2 questions are:

 

1) Does the Paratemer need to be called RangeStart and RangeEnd? Or is this just a name of the parameter and has no impact on the functionality?

2) Then on the data table in the query editor I filter the specific column in the parameter to is on or after the start parameter and before the end parameter?

 

Then close and apply and select table I want to incremental refresh and select amount of time to keep and amount of time to refresh and then publish to the service?

 

I suppose just looking for some plain language rather than copy and paste from the post.

 

Thanks

 

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi jpt1228 ,

 

Answers for your questions are:

 

1.Yes, Paratemer needs to be called RangeStart and RangeEnd.

2.Yes,you did right.

 

I guess you have understood how to set the Incremental Refresh,just have a try,be sure that you do it in a Premium account.

 

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

 

  • jpt1228's avatar
    jpt1228
    Responsive Resident
    6 years ago

    Hello v-kelly-msft  I have configured the data model to incremental refresh as noted above. When I publish to the service and try to refresh I get the following error:

     

     

    You mentioned it needs to be a premium account but in the Feb update it is now included in the pro version.

     

    Thanks

     

    Jon