Display scheduled refresh detail below the dashboard title

[Anonymous]

Hi,

I have to display the refresh schedule details below the dashboard title. I have been scheduled the dataset and tested it but this schedule detail is not diplaying on dashboard. 

It should display like : Refresh Schedule: Daily 9:00 AM . REFRESHED: 07/09/19. 09:23:45 PM

Please suggest how to do it in power bi service.

Thanks,,,,

[TeigeGao · Accepted solution]

Hi @Anonymous ,

In your scenario, we can use the following DAX query:

Last Refreshed (Local) = FORMAT(LASTDATE(LastRefresh_Local[LastRefresh]),"mmm dd, yyyy hh:mm:ss AM/PM")

Please refer to this blog: https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/

Best Regards,

Teige