Forum Discussion

DataJAM's avatar
DataJAM
New Member
2 years ago
Solved

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 sho...
Need Help
  • vicky_'s avatar
    vicky_
    2 years ago

    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

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
2 years ago

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