Power BI Refresh Date/Time

From today's Power BI User Group, I saw @Rebecca Sundquist using Power Query's M code of get local time to get a table of last refreshed date/time for the Power BI. I remember there was reason why I didn't do that, and can't remember.

Now, I remember, so I want to put this out here so others can be aware, as well as for myself to remember why I had to do something more complex. @Erik Leaver maybe somehow post this along with the recording for others to see?

Using DateTime.LocalNow() only “works” while you are on Power BI Desktop, as the Desktop knowns your local time zone. When published to the Power BI Service, it operates in UTC time.

Another method is to do timezone hours adjustment, that works well IF you are at a location that doesn't have daylight savings, otherwise, every time daylight savings change, you have to account for the +1 and -1. So that's not workable for me.

Instead I use a web service that will give me the date/time I need for the timezone and it auto accounts for daylight savings: https://worldtimeapi.org/api/timezone/America/New_York

Below is the Power Query M-code for doing this.

let
Source = Json.Document(Web.Contents("https://worldtimeapi.org/api/timezone/America/New_York")),
#"Converted to Table" = Table.FromRecords({Source}),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"abbreviation", type text}, {"client_ip", type text}, {"datetime", type datetimezone}, {"day_of_week", Int64.Type}, {"day_of_year", Int64.Type}, {"dst", type logical}, {"dst_from", type datetime}, {"dst_offset", Int64.Type}, {"dst_until", type datetime}, {"raw_offset", Int64.Type}, {"timezone", type text}, {"unixtime", Int64.Type}, {"utc_datetime", type datetime}, {"utc_offset", type duration}, {"week_number", Int64.Type}})
in
#"Changed Type"