Forum Discussion
Power ParticipantPower Bi Date/Time different to SP Source Data
I previoulsy noticed that the date field in my BI Report is out by a day and therefore simpy created a new column with +1 day, which fixed the issue. Unfortunately, I now need to use a date/time column and this has highlighted a bigger issue. As you can see from below, either the date/time or time in the BI report doesnt match the SP List source data. I've been searching Google and here, but getting mixed answers and therefore posting here. I have checked with the SP guys and the SP timezone is GMT+1, where as I beleive BI is UTC.
From the examples below, the fist row is 1hr behind, where as the 2nd row is 2hrs behind, but suspect this relates to daylight saving.
How can I correct this as I really need the BI Report to match the SP Date\Time.
Thanks in advance.
1 Reply
v-jingzhangCommunity Support
Hi StuartSmith
You have to convert the UTC time into local time including daylight savings. This can be done with Power Query. Here are some examples:
Handling local time zone with Daylight Savings in Power BI Service
Convert Date/Time in UTC to Local Time with Daylight savings
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.