Time on PowerBI desktop different from that in Service

[IvanOboth]

Hi all,

I have a simple visual card showing the latest refreshtime of my report. however, when i publish this to PowerBI service, the time shown (GMT) is different to that in the PowerBI desktop file (GMT+3). Any ideas on how i can fix this?

[BhaveshPatel]

Hi There,

Try this and It will work.

Enter this M formula into a blank query in the get data button:

= DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),-3))

The -3 at the end is for +3 GMT. 

Use Multi Row Card visual for showing this data.