Forum Discussion
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...
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
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.
EST means Eastern Standard Time. EDT means Eastern Daylight Time.
So, it depends on the time of the year that you use the abbreviation. EDT during spring and summer and EST during fall and winter, due to DAYLIGHT savings.