Forum Discussion

virakones's avatar
virakones
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Sharepoint List adjusted to Date/Time/Timezone & Using Locale showing incorrect time

I have a Sharepoint list that captures Start/End times to jobs.   The times are collected in EST (-04:00) ex. 6/3/2022 8:19 AM EST   When brought into PowerBI they show up as UTC so I h...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi virakones ,

     

    Power BI Service always returns the UTC time. We can't set the time zone on Power BI Service. To get the correct local time, we can add time different in your DAX formula, or use Power Query to get the local time zone datetime. For more details, please see: Solving DAX Time Zone Issue in Power BI.

     

    Best Regards,

    Jay

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Power BI Service runs on UTC.  As long as you keep your timestamps in ISO-8601 format you should be good.

 

By the way, it's EDT, not EST.