Forum Discussion

XadrB's avatar
XadrB
Regular Visitor
2 years ago

Help with Datamart/Dataflow: "Column1 not found"

Hello everyone,   We are facing two errors when using Incremental Refresh in a Datamart (the same issues occurs in a Dataflow, so I'll refrain from mentioning both).     let RangeStartText = Da...
dataflow
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Column1 will not exist if the list is empty.

 

Note that RangeStart must be inclusive and RangeEnd must be exclusive.

 Incremental Refresh in the datamart inputs the dates itself, which causes an error. Our API has no data from the date 1.1.1 to 31.12.9999

Not sure where you get that date range from, but it would be catastrophic.

 

What are your incremental refresh partition rules?