Forum Discussion
PowerBI does not support RangeStart/RangeEnd as Edm.DateTimeOffset with incremental refresh
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.
Hi dzendras
You can convert DateTime to integer then configure incremental refresh follow the steps in Incremental refresh doc .
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.
2 Replies
- lbendlin
Super User
Incremental refresh also supports date numerals. Maybe that's an option for you?
Configure incremental refresh for Power BI datasets - Power BI | Microsoft Docs
Hi dzendras
You can convert DateTime to integer then configure incremental refresh follow the steps in Incremental refresh doc .
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.
