Forum Discussion

Jaspal's avatar
Jaspal
Regular Visitor
2 years ago
Solved

Increment Refresh Duplicate row error

Morning (Odata connection)   I have a  RangeStart 01/01/2023 00:00:00 RangeEnd 31/12/2026 23:59:59 I implemented a dax fileter = Table.SelectRows(BaseOrder_table, each [SysMutationDateTime] => Dat...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    last date change / last modified  may not be a good candidate.  Ideally you want some immutable column like Order Create Date.

lbendlin's avatar
lbendlin
Super User
2 years ago

Is SysMutationDateTime the right column for your partition management or is it possible that you have different values within the same order (for example if you have order line item granularity)?

 

The format of your order number should be Integer or text.

Jaspal's avatar
Jaspal
Regular Visitor
2 years ago

I changed the sys mutation date to last date change (date and Time format) and the format of order number is test running it as we speak 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    last date change / last modified  may not be a good candidate.  Ideally you want some immutable column like Order Create Date.