How can I do an incremental refresh with null dates??

[Paguiar]

I would like to know if it is possible to do an incremental refresh or just a "reload" (working with a smaller range of dates on the desktop) and that this column of dates contain null dates ​​.

For example, I have a [Payment Date] column, and I need it to have blank values ​​in it.

I've already tried and it didn't work:

Select *

from table

where  [Payment date) between Range start and RangeEnd or [Payment date] is null.

But the null values have duplicated

Is there another way?

[Anonymous]

Hi @Paguiar ,

Unfortunately, the feature you want is currently not available. Maybe you can sumbit an idea for it: Ideas

Date column - The table must contain a date column of date/time or integer data type. The RangeStart and RangeEnd parameters (which must be date/time data type) filter table data based on the date column. For date columns of integer surrogate keys in the form of yyyymmdd, you can create a function that converts the date/time value in the parameters to match the integer surrogate key of the data source table. To learn more, see Configure incremental refresh - Convert DateTime to integer.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You need to remember that RangeStart and RangeEnd identify the boundaries of the dataset table partitions. That's one of the reasons while only one of the parameters can be inclusive - otherwise you risk duplicating data across adjacent partitions. Same with your null dates.  Unless you substitute these with a fixed date you will have duplicate rows in your partitions. You really don't want that to happen.