Solved: Last refresh time problem

BeemsC · ‎12-07-2017

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?

v-chuncz-msft · ‎12-07-2017

@BeemsC,

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎12-07-2017

@BeemsC,

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dilumd · ‎12-07-2017

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 · ‎12-07-2017

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