Forum Discussion
Changing Web workspace schedule refresh to stick with local time instead of UTC time.
Hi all, I have scheduled a daily refresh at local time UTC +8:00 (every 7AM). However, the Bi board refreshed date shows UTC +0:00 time instead (which is last night 11pm), resulting my data not refreshed to the latest info as of local time 7am.
Is there a way to let the report shows 7am local time data when it is daily refresh?
This is a trigger to refresh every 7am local time UTC +8:00:
This is the web version workspace that shows UTC +0:00 time, which is yesterday 11pm data instead:
3 Replies
- mussaenda
Community Champion
Hi anonymous1124 ,
on your power bi desktop, add 8 hrs to your Last Refreshed column, publish it then trigger the refresh
Hi, This is my last refreshed table, may i know how do i add the 8 hours into it?
Im based in singapore so local time utc +8:00
- mussaenda
Hi anonymous1124 ,
You are looking for a power query solution right? because the question is posted in power query section.
Create a custom column and do like this
Solved: How to add hours to DateTime data? - Microsoft Fabric Community
