Last Refresh Visual Update in Web - How to make it work ?

[Anonymous]

Hi

I have made a "Last Refreshed" date & time visual in power BI desktop. Thus, each time i click refresh, the latest time & date will be updated in this visual.

However, when i publish my dashboard to power bi web and when data is refreshed (yes the latest data appears in dashboard), but the date and time of the last refreshed visual remains unchanged. How can i make it work ?

Please advise.

[v-rzhou-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

[v-rzhou-msft]

Hi @Anonymous 

If you want to show last refresh time in card visual, you can build a last refresh table in Power Query Editor by Query

DateTime.LocalNow().

In this column it will show the last data refresh datetime.

Then build a card visual by this column and publish this report to service.

Let's see the result.

It is the same as the refresh success time in my refresh history.

If you use Now() function in measure, it will update even you refresh the browser. So it won't show the data refresh time correctly.

For more details about getting refresh datetime,you may refer to this video:

How do you get a REFRESH DATE in your Power BI report???

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

Hi, yes i have done the same way that you have suggested. But there is a variance in time. Do you know why ?

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

Both refresh datatime are correct.

They are the same datetime which are shown in different Time zone.

You may refer to this blog for more details about showing datetime in Time zone you want:

Display Last Refreshed Date in Power BI

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , if you have used Now() in measure and use that in a card that should give current/latest time.

Also, refresh on power bi service refresh the page and remove the filter(if it import mode). So not refresh data.  For that, you have to schedule a refresh https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh

Are you on a direct query mode or import mode