Forum Discussion
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. ...
There are Power Query functions to shift timezones, or you can use #duration.
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?
In such scenarios I always use UTC everywhere.