Forum Discussion
Timezone EST and UTC issues - Incremental Refresh and Power BI Service
I had some issues with incremental refresh but after I solved that with help from this forum now I have whole another issues with timezones. I have power query which calls external API and since I am using incremental refresh I am using RangeStart and RangeEnd parameters for the datetime. How do I do this so that I send dates to API in UTC format (since Power Bi Service is in this format) but have my slider visual that works with EST dates?
16 Replies
Hi, stribor45
Try exploring Date timezone.SwitchZone and To local() in PQ.
Refer: https://learn.microsoft.com/en-us/powerquery-m/datetimezone-switchzone
https://learn.microsoft.com/en-us/powerquery-m/datetimezone-tolocal
Alternatively you can use Dax to solve the Viz problem.
Use Dateadd and -5, hour as the solution along with your UTC date time column name.
Yes EDT my bad. I always mix up between these. You are right it is EDT
Run everything in UTC, and then in your user interface subtract 4/24 from the datetime value to feed your slicer.
Can you share small example if possible?
When I enter my parametars in Zulu time it automatically converts them?
The values you enter there do not matter at all. The Power BI service will replace them during the incremental refresh according to the partition rules and based on UTC (Zulu).
is there a way to see what API query is sent out by the service?
