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
4 years ago

in M code Centaltimeoffset is Contains not correct please help me for these