Forum Discussion
PowerBI modifying time by 1 hour from SharePoint List Dataset
Hiya,
I'm building a report using a Sharpeoint list as a datasource. This includes 2 deperate colums with Date/Time type. When PowerBI pulls the Date/Time to display in my report, it's modiyfying the time by 1 hour.
For example, this entry has a Date Identified as 17/05/2022 15:25 but the reports displays this as 17/05/2022 14:25.
Sharepoint List:
PowerBI report:
I'm wondering what the issue is and if anyone can help? 😊
Hi RumSwift ,
This might be caused by UTC time zone. You may refer to the following thread to add a new column.
http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337
Add the UTC offset to your formula.
Measure = NOW () - 8 / 24Did I answer your question? Mark my post as a solution!
Best RegardsLucien
1 Reply
- v-luwang-msft
Community Support
Hi RumSwift ,
This might be caused by UTC time zone. You may refer to the following thread to add a new column.
http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337
Add the UTC offset to your formula.
Measure = NOW () - 8 / 24Did I answer your question? Mark my post as a solution!
Best RegardsLucien