Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
2 years ago

Incremental Refresh

I am trying to test incremental refresh and in my power query i have data from January 1 2024 until today.  I also  have set up  parameters (RangeStart and RangeEnd) to be between April 1 - April 9. ...
Need Help
Tips and Tricks
stribor45's avatar
stribor45
Post Prodigy
2 years ago

my numbers in visual in Desktop and Service do not match.  I saw some posts where dates in Service are in UTC

lbendlin's avatar
lbendlin
Super User
2 years ago

That's correct. Incremental Refresh uses a regular UTC calendar.

  • stribor45's avatar
    stribor45
    Post Prodigy
    2 years ago

    so my RangeStart and RangeEnd need to be adjusted? My API endpoint takes DateTime values using my offest. how do I adjust them?

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      There are Power Query functions to shift timezones, or you can use #duration.

      • stribor45's avatar
        stribor45
        Post Prodigy
        2 years ago

        I am more concerned about how this work. In my Desktop I call APIs which accept datetime like this with my time zone being 4 hours behind. i have to call it this way because by numbers depends on it. 

        DateTime.ToText(RangeStart,"yyyy-MM-ddTHH:mm:ss-04:00")

         As you said before when refresh happens on Service side which after initial set up they will and since it is UTC time how do i do that? I dont understand how at the same time I call API's with EST time (-4 hours) and in service I call API with UTC time?