Changing Web workspace schedule refresh to stick with local time instead of UTC time.

[anonymous1124]

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:

[mussaenda]

Hi @anonymous1124 ,

on your power bi desktop, add 8 hrs to your Last Refreshed column, publish it then trigger the refresh

[anonymous1124]

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