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

Anonymous's avatar
Anonymous
Not applicable
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