Forum Discussion

IvanOboth's avatar
IvanOboth
Icon for Advocate I rankAdvocate I
9 years ago

Time on PowerBI desktop different from that in Service

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?

1 Reply

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

     

    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.