Forum Discussion

Incipient's avatar
Incipient
Helper I
4 years ago

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...
Need Help
Incipient's avatar
Incipient
Helper I
4 years ago

Haha yes, you got me on a technicality - I should have said the dataset, not the report.

 

I think this however is a timezone issue. Some of my logic I had accidently used LocalNow() instead of UtcNow(). I expect the PowerBI service uses UTC as it's refresh timezone? so when it was doing a daily refresh, "today" for us at 9am, is still "yesterday" for UTC.

 

I have fixed this and was going to monitor until tomorrow to sure this was the correct fix.

 

Thanks for the info/reply lbendlin ğŸ™‚ 

lbendlin's avatar
lbendlin
Super User
4 years ago

Correct, the Power BI service runs on UTC. However, the dataset refresh schedule dialog allows you to specify a different timezone.

  • Incipient's avatar
    Incipient
    Helper I
    4 years ago

    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.