Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Time Zones and Scheduled Refresh

I created a table to show the latest refresh day and time for my reports, had issues when I scheduled a refresh through the Power BI service, and reading through here found the cause of the error (I ...
Need Help
  • blopez11's avatar
    blopez11
    7 years ago

    Yes, I have the value displaying on my reports so the user knows when the data was last refreshed

blopez11's avatar
blopez11
Icon for Super User rankSuper User
7 years ago

Here are the M steps that I used that seem to work fine (CentralTimeOffset is a parameter)

Though they don't look much different to what you are doing

Good Luck

 

#"Added Refresh Date Time (UTC)" = Table.AddColumn(#"Changed Type", "Refresh Date Time (UTC)", each DateTimeZone.UtcNow(), type datetimezone),
#"Added Refresh Date Time (CST)" = Table.AddColumn(#"Added Refresh Date Time (UTC)", "Refresh Date Time (CST)", each DateTimeZone.RemoveZone ( DateTimeZone.SwitchZone ( [#"Refresh Date Time (UTC)"], -CentralTimeOffset ) ), type datetime)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Okay thanks. And this works for scheduled refreshes through the Power BI service?

  • blopez11's avatar
    blopez11
    Icon for Super User rankSuper User
    7 years ago

    Yes, I have the value displaying on my reports so the user knows when the data was last refreshed

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      That worked, thank you!