Skip to main content
cancel
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.

Reply
anonymous1124
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:

anonymous1124_0-1693446633988.png

 

This is the web version workspace that shows UTC +0:00 time, which is yesterday 11pm data instead:

anonymous1124_1-1693446761866.png

 

3 REPLIES 3
mussaenda
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

 

anonymous1124_0-1693464491578.png

 

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

mussaenda_0-1693465094119.png

Solved: How to add hours to DateTime data? - Microsoft Fabric Community

 

Helpful resources

Announcements
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

PBI_APRIL_CAROUSEL1

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