Forum Discussion

BeemsC's avatar
BeemsC
Resolver III
8 years ago
Solved

Last refresh time problem

Hey all,

I've seen posts about this, but couldn't find the appropiate solution for this.
I have a card which shows my last refresh date, i did it doing the following:

''  Last refresh column = NOW()  ''

Then i use this measure in the card:

'' Last refresh date = MAX('tbl_sales'[Last refresh column]) ''

Everything works fine in desktop.
But when i upload the report onto Service it shows the last refresh time - 1 hour.
So instead of 11;00 it would show 10;00.
Does anyone have any idea on how to fix this?

Need Help

3 Replies

  • dilumd's avatar
    dilumd
    Impactful Individual
    8 years ago

    Hi BeemsC

     

    On your dashboard you can click on "three dots" towards the right hand side of a tile and go to "edit details" to enable last refresh time.

     

     

    I think this serves the same purpose which your trying to achieve.

    • BeemsC's avatar
      BeemsC
      Resolver III
      8 years ago

      Hey,

      Thanks for the reply.
      The problem is, instead of first going to a dashboard and the clicking on it, it's added as a report.
      I don't think it's possible for this case

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    BeemsC,

     

    It shows the current date and time in UTC. There is already an idea, you may leave a comment and vote it up.