PowerBI does not support RangeStart/RangeEnd as Edm.DateTimeOffset with incremental refresh

[dzendras]

I am trying to enable incremental refresh with my OData V4 feed following the instructions from https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

Unfortunately RangeStart/RangeEnd must be of type Date/Time (Edm.DateTime), while OData V4 obsoleted this type and forced all Date/Time properties to be of type Edm.DateTimeOffset. When those parameters are Date/Time/Zone then incremental refresh cannot be conifgured (Incremental Refresh toggle is disabled). If I revert my feed to V3 (and Edm.DateTime), then the toggle is enabled.

[v-yetao1-msft · Accepted solution]

Hi @dzendras 

You can convert DateTime to integer then configure incremental refresh follow the steps in Incremental refresh doc .

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#convert-datetim...

Best Regards

Community Support Team _ Ailsa Tao

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

[lbendlin]

Incremental refresh also supports date numerals. Maybe that's an option for you?

Configure incremental refresh for Power BI datasets - Power BI | Microsoft Docs