Skip to main content

Power BI

Completed

Provide an easy way to display the last refresh date/time in a dashboard

Vote (58) Share
Don Potts (OFFICE CAPES)'s profile image

Don Potts (OFFICE CAPES) on 16 Dec 2014 03:11:00

We update a real-time dashboard every 15 minutes (time interval is configurable). We want to let people know how fresh the data is and reassure ourselves that the dashboard is still running, so we display the last refresh date/time in the upper right corner of the dashboard. We need a simple way to do this that doesn't require VBA (what we currently use to trigger the refresh and set the date/time value in the cell). Thanks!

Comments (5)
Don Potts (OFFICE CAPES)'s profile image Profile Picture

fdbb6a7c 59b9-4788-94b9-e2d1b0731fab on 05 Jul 2020 22:20:04

RE: Provide an easy way to display the last refresh date/time in a dashboard

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

Don Potts (OFFICE CAPES)'s profile image Profile Picture

ec12373a d7e5-4239-a68b-ddfb695c66a2 on 05 Jul 2020 22:18:17

RE: Provide an easy way to display the last refresh date/time in a dashboard

I am also looking for a way to show last refresh date in a dashboard. any solution for this?

Don Potts (OFFICE CAPES)'s profile image Profile Picture

a74e63bd 01c0-4046-8de9-fab6e04bfbbc on 05 Jul 2020 22:12:16

RE: Provide an easy way to display the last refresh date/time in a dashboard

This is especially useful when information is periodically being published up from a local source

Don Potts (OFFICE CAPES)'s profile image Profile Picture

251f8db0 dd10-4b08-a05f-ec3294d6ffd7 on 05 Jul 2020 22:10:43

RE: Provide an easy way to display the last refresh date/time in a dashboard

When having distributed reports on Azure-based services (hence refresh is scheduled maximum 8 times per day) - it would be useful to have an object stating the last successful refresh-time. So that there is no confusion on the data expected to be visualized. A timestamp on metadata-level for the dataset could be a good solution. This information is already available on the publisher dataset - but not on the distributed level.

Don Potts (OFFICE CAPES)'s profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:05:58

RE: Provide an easy way to display the last refresh date/time in a dashboard

Will, how do you go about adding this as a datasource?