Solved: UTC Timezone Issue

DataJAM · ‎10-02-2024

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?

vicky_ · ‎10-02-2024

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

View solution in original post

vicky_ · ‎10-02-2024

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