Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Scheduled Refresh Errors with the Dates

Hi Everyone, I have a Fact table with some sales data and a date column and a separate date Table created in DAX with the CALENDARAUTO(). The tables are linked together in the data model by the date...
help.
  • lbendlin's avatar
    lbendlin
    2 years ago

    change your filters to account for the service UTC.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I tried this today and it looks fine on the power bi desktop and even after i publish it to thhe report server
The problem comes when the scheduled refresh runs, the visuals which have the date from the date table as the axis become blank, any idea what might be the reason?

lbendlin's avatar
lbendlin
Super User
2 years ago

Timezone differences?  The Power BI Service runs on UTC.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I'm on UTC +3... any idea to adjust the data after it has been refreshed?

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      change your filters to account for the service UTC.