topic Re: last time refresh in Service

last time refresh

nirrobi — Mon, 21 Sep 2015 16:03:29 GMT

Hi,

Is it possible to add to the report/dashboard the date and time of the last refresh?

Many thanks.

Nir

Re: last time refresh

Anonymous — Mon, 21 Sep 2015 16:31:47 GMT

nirrobi Is this for troubleshooting purposes? Just to point out, you can see when the dataset that supports the reports/dashboards was last refreshed. Just click the elipses of the dataset that currently has a scheduled refresh set and it will show you when the last refresh was, and when the next one is scheduled.

You could then assume that all reports / dashboard tiles should be updated based on that date/time.

Re: last time refresh

Greg_Deckler — Mon, 21 Sep 2015 17:04:51 GMT

No way that I know of. This would be SUPER helpful. When you share out a dashboard, not everyone will be able to see when it was last refreshed without this. And this will be the first things people ask or want to know about..."How recent is this?"

Re: last time refresh

nirrobi — Mon, 21 Sep 2015 17:06:01 GMT

Thanks for the reply.

Its not for troubleshooting but to know we the last refresh was.

Meantime I have problem with the schedule refresh and want to know the last time the dataset was refresh, is it possible?

I want to have tile with last time the dataset was refresh.

Regards,

Nir,

Re: last time refresh

nirrobi — Mon, 21 Sep 2015 17:10:34 GMT

Hi,

Maybe this will solution will help,

http://www.powerpivotpro.com/2010/11/add-a-last-refreshed-date-readout/

I will try tommorow and update :-)

Re: last time refresh

idanco — Wed, 07 Oct 2015 10:35:05 GMT

Hi nir,

You can add a calculated column (Last Refresh Column) in the model with the formula =NOW()

And measure Last Refresh Date :=MAX(Table[Last Refresh Column])

Since calculated columns are calculated only on model refresh - it will make sure the calc is right

Re: last time refresh

crazytown — Mon, 01 Feb 2016 16:50:20 GMT

This was showing the last time I ran my report but now seems to have disappeared again ... anyone know why please?

Re: last time refresh

AStolk — Tue, 01 Mar 2016 13:28:43 GMT

Within Power BI Desktop, this works fine! However, after publishing this to PowerBI.com and executing a refresh within the browser, the result of the Last Refresh Date is always displaying an hour too early. It looks like it's refreshing and displaying the last refresh date and time in GMT timezone, but I'm in GMT+1. Is it possible to take into account the timezone?

Re: last time refresh

skiwi — Fri, 22 Apr 2016 01:50:01 GMT

You can show this on a tile in a dashboard by clicking the ... on the top right hand corner of the tile, then click the edit pencil, then check the "Display last refresh time". The refresh time will now show at the top of the tile

Re: last time refresh

GilesWalker — Fri, 22 Apr 2016 06:58:31 GMT

This worked for me and takes into account that when the auto refesh on PowerBI.com occurs it is done in GMT time:

Enter this M formula into a blank query in the get data button:

= DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),-10))

The -10 is becasue I am +10 GMT. Not sure why it needs to be negative but it is.

Hope this works.

Giles

Re: last time refresh

pmendoza — Fri, 22 Apr 2016 09:12:44 GMT

This is not possible in either my Desktop or Service . Am I missing something?

Thanks!

Re: last time refresh

Virtual_Ames — Tue, 21 Jun 2016 18:23:58 GMT

I believe this is the right solution to the time issue - but it is not clear how to enter the M code. Blank query does not indicate a clear path to entry.....

Could you perhaps clarify your answer a bit? I'd like to implement this and test....

Thanks,

Brian

Re: last time refresh

wynhopkins — Tue, 16 Aug 2016 08:48:34 GMT

Not sure when this feature was added but I just spotted it today

Click on the ... in your dashboard, clcik on the pencil to edit, select display last refresh

Re: last time refresh

Rajkumar — Tue, 06 Sep 2016 11:17:12 GMT

Hi All,

Add a column to your dataset with the below formula.

Last Refresh Date Time =DateTimeZone.LocalNow()

This will get refresh only,when you click the refresh button. It is working 100% correct. I'm using in my current project PBI Reports.

Re: last time refresh

Rajkumar — Tue, 06 Sep 2016 11:25:55 GMT

Add a column to your dataset with the below formula.

Last Refresh Date Time =DateTimeZone.LocalNow()

This will get refresh only,when you click the refresh button. It is working 100% correct. I'm using in my current project PBI Reports.

Re: last time refresh

Rajkumar — Tue, 06 Sep 2016 11:30:19 GMT

Hi ALL,

Add a column to your dataset with the below formula.

Last Refresh Date Time =DateTimeZone.LocalNow()

This will get refresh only,when you click the refresh button. It is working 100% correct. I'm using in my current project PBI Reports.

Re: last time refresh

vkdubw — Fri, 07 Oct 2016 20:39:48 GMT

I am seeing all these people saying to hover over the tile and click the elipse button... but I do not get the edit or pencil icon when clicking the elipse button when in the dashboard or report. Is there an IE/Edge configuration I need to uncheck in order to get the edit (pencil) button when clicking the elipse button?

Thanks.

Re: last time refresh

wynhopkins — Fri, 07 Oct 2016 22:59:46 GMT

Hi vkdubw, I'm not aware of any issue. My dashboards are not affected by Chrome or Edge.

Are you able to post a screenshot?

I'm not sure if the source of the dashboard is an issue. Are you getitng your dashboard from a Content Pack or just creating it yourself?

Re: last time refresh

vkdubw — Fri, 07 Oct 2016 23:07:34 GMT

Thanks for the quick response. Hereare the screenshots from theDashboard (Lst 24 hours) and the Report (Export Only). I originally created the dashboard with PBI Desktop and published.

Re: last time refresh

wynhopkins — Fri, 07 Oct 2016 23:12:59 GMT

No problem vkdubw, it looks like your screenshots are from the report view (I can siee the pin to dashboard icon)

The last time refreshed ellipse is only available in the Dashboard view. So if you use the pin icon to add the visual to a dashboard then you shold see a different set of options on the elipse when in Dashboard View