Forum Discussion
Incremental Refresh with data source with only Date/Time/TimeZone format date
I use Odata feed to fetch my data, the 'View Native Query' is disabled from the start, but i saw in the 'Diagnose step' that when i filter some column - the HTTP request is using $Filter, so i guess that my source can folding, my problem is that all the Dates column in my source is in Date/Time/TimeZone format, when i create new column or change some date column format to work with RangeStart and RangeEnd - its look like the HTTP request does not longer use $filter, and Incremental Refresh does not work..
I think that the problem is that my source need format Date/Time/timeZone to filter in the server side, there is somthing i can do to achive Incremental Refresh?
1 Reply
- lbendlinSuper User
What timezone is your server running on? If it is on UTC (as it should be) then the standard DateTime column type is sufficient.