Time zone question

[sanimesa]

I am trying to add a last refresh date and using the solution suggested here: 

https://www.fourmoo.com/2017/03/28/power-bi-create-last-dataset-refresh-date/

However, the refresh time shown on the service is always the UTC time, no matter what I set the switchzone parameter to:

TodaysDate = DateTime.From(DateTimeZone.SwitchZone(DateTimeZone.FixedLocalNow(),-6)),

On the desktop (EST), it always shows the EST time. 

Is this expected behavior? 

[v-yulgu-msft]

Hi @sanimesa,

Please try the workaround in this blog to see if it works in your scenario:

Display Last Refreshed Date in Power BI

Best regards,

Yuliana Gu

[sanimesa]

@v-yulgu-msft  I have seen that solution and tried it too, but it did not work. Does not seem like a feasible solution. Is there a system or environment variable that provides the last refresh time?