Incremental Refresh

Hi, datetime data type is the correct type.
However, if you can try to create a function in Power Query editor that converts to datetime data type to number type (for date_key column in fact tables) or date type (date column in fact tables), then I think you can implement in a way that you expected.
Thank you.

Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn

 

Hi UncleLewis ,

Thanks for reaching out to Microsoft Fabric Community.

As mentioned by Jihwan_Kim , Power BI requires the column used for Incremental Refresh to be of datetime type at the filter step for RangeStart and RangeEnd to bind properly.

 

If your source table only has a date column or uses integer surrogate keys in yyyymmdd format, you'll need to convert the RangeStart and RangeEnd parameters accordingly by creating a function to map the datetime values to match the format used in your table. This is particularly useful when your fact table uses surrogate keys instead of native datetime columns.

 

You can refer to the Convert DateTime to integer section in the official documentation for that approach.

 

Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn

 

Hope this helps. Please reach out for further assistance.

Thank you.