Forum Discussion
Incremental Refresh Date Parameters
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,
KellyDid I answer your question? Mark my post as a solution!
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.
Kelly
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