Adjusting SharePoint Created/Modiifed Timestamp columns for TimeZone

I've got a PowerBI dashboard that is built primarily from a SharePoint list data.

I noticed yesterday I had neglected to account for time zone differences.  A list item was modifed yesterday at 8pm, but it showed as modified at 2am the following date in my dashboard.  I'm in central US time, so -0600 offset from UTC, so it's definitely a timezone issue.

So I went into my query and created a calculated column called "LocalModified" with this formula:

= Table.AddColumn(#"Renamed Columns", "LocalModified", each DateTime.AddZone([Modified],-6))

But it didn't return the results I expected.  I thought that perhaps I should instead just add the time zone component to the original column using this formula instead:

= Table.AddColumn(#"Renamed Columns", "LocalModified", each DateTime.AddZone([Modified],0))

(The only difference is I'm setting the timezone to "0" or UTC). But still not the results I wanted.

But researching I found this gem:

DateTimeZone.ToLocal(DateTime.AddZone([Modified],0)

This appears to work great in PBI desktop, but I hope it still uses central time as "local" when I upload this to the service.