How to avoid having date and date/time column (Incremental Refresh and Calendar Table)

Hi IvanKostov ,

If you need a date column (calendar relationship) and you need a datetime column (incremental refresh) then you need a date column and a datetime column, no way around that I'm afraid.

In Power Query, keep your datetime column as-is, then create a new custom column using the following:

Date.From([datetimeColumn])

Using Date.From will prevent query folding from breaking if your source is foldable.

Pete