Incremental refresh on a column with 'date' format

[PushkarP]

Hello,

I am trying to configure incremental refresh on a table. I have configured 'RangeStart' and 'RangeEnd' parameters. Now I want to apply filter using these parameters on a Column named 'Sent date' which is of date format, so I am unable to apply the filters. What do I need to do? Please note the column 'Sent date' has relationship with another table hence I cannot change its format to datetime in Power Query.

Thank you in anticipation.

Regards,

Pushkar

[AllisonKennedy · Accepted solution]

Duplicate the column and set the data type of the new column and use that for your incremental refresh.
As a side note/bonus, I typically use a DateKey in the format "yyyyMMdd" as my column to use for relationships with Date table.

[PushkarP]

@AllisonKennedy 

Thanks for suggestion, I created a new column for incremental referesh.