DateTime changes to GMT when report published? *How to get last refreshed date?

I have a dataset that I created in PBI desktop which comes from an SPO list.

I added a custom column with LastRefreshDateTime = NOW()

When I view it in desktop it works fine of course, then I publish it.

Once it publishes to the service I get this:

I tried changing the date time format in desktop and re-publishing but it does not seem to make any difference.

Changed date format again:

*Am I picking a bad date time format?

It is odd because in desktop it shows the filed thusly:

2/23/2018 8:16:47 AM

I don't really understand the disconnect.

How can I convert that to a timezone of my choosing?  

Is there a better way to get the last refreshed date of the datasource in the SPO list query?

Thanks!