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!

     

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

Hi jpt1228 ，

1.For Current Value，it is just a text field .

 

2.Verify queries have an equal to (=) on either RangeStart or RangeEnd, but not both. If the equal to (=) exists on both parameters, a row could satisfy the conditions for two partitions, which could lead to duplicate data in the model. For example,
#"Filtered Rows" = Table.SelectRows(dbo_Fact, each [OrderDate] >= RangeStart and [OrderDate] <= RangeEnd) could result in duplicate data.So you cant filter your data table on is after or equal to: Parameter DateStart and is before or equal to Parameter DateEnd.

 

Here is the reference.

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!
parry2k's avatar
parry2k
Super User
6 years ago

v-kelly-msft not sure what you mean by text field.  you cannot just type random value there, if you have selected parameter type to be date/time then it has to be valid date/time value, not sure what you mean by text. Can you clarify?

 

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

    Hi parry2k ,

     

    As jpt1228 asked " Is this just a text field or does it need to be dynamic or formula driven?",I just followed his understanding to say it is a text field,I just wanna tell him it is not formula driven or dynamic automatically.

    But I know it's not a rigorous saying,thank you for correcting me.

     

     
    Best Regards,
    Kelly