Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

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:



Super User
Super User

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




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


Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors