cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BeemsC
Resolver III
Resolver III

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?

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@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

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@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
Solution Supplier
Solution Supplier

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.

 

1.JPG

 

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

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors