Forum Discussion
Report Visuals with Stale Data?
I have a report that updates daily in the morning, say 7am. At 9am the report - after it has refreshed - still has the previous day's data. Edit: only some visualisations are stale; some large tables...
Correct, the Power BI service runs on UTC. However, the dataset refresh schedule dialog allows you to specify a different timezone.
I've set the refresh schedule to be my timezone, but localNow() ignores the timezone, possibly because it's DateTime.localNow() rather than the DateTimeZone class? Definitely a 'gotcha' when using PowerBI - they have a timezone option that is easy to mess up!
I do feel like this is a bit in 'bug' territory. I would expect localNow() to use the refresh timezone I had set.