Forum Discussion
UTC Timezone Issue
I think I am having a timezone issue and would greatly appreciate any assistance/advice offered. I created a dashboard in desktop that includes measures with adjusted timezone for EST time -5. It shows the correct data in the desktop version but once I upload to Service, all of the data in the visuals change completely. I tried creating a timezone/dst table but that didn't solve my problem. Not sure if I'm doing it correctly or what the solution to my problem is. Can anybody assist me with this?
The issue is that PowerBI service uses UTC time, but your desktop will use your PC's local time, unless you've manipulated the time somehow. There's a few ways to get around this, but I think thje most common is to use PowerQuery to convert your data to UTC time, or otherwise, create a new table that contains the actual date / time in your local timezone to use as a filter.
This article goes into more detail on how to achieve that: https://radacad.com/solving-dax-time-zone-issue-in-power-bi
1 Reply
The issue is that PowerBI service uses UTC time, but your desktop will use your PC's local time, unless you've manipulated the time somehow. There's a few ways to get around this, but I think thje most common is to use PowerQuery to convert your data to UTC time, or otherwise, create a new table that contains the actual date / time in your local timezone to use as a filter.
This article goes into more detail on how to achieve that: https://radacad.com/solving-dax-time-zone-issue-in-power-bi