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 refre...
mussaenda
Community Champion
Community ChampionHi 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