Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • What timezone is your server running on?  If it is on UTC (as it should be) then the standard DateTime column type is sufficient.