Last Refreshed Date based on refresh schedule in Power BI Service

Hi DagmaraG ,

There's broadly two ways to achieve this:

-1- In Power Query, create a new query that is just:

let
    Source = DateTime.FixedLocalNow()
in
    Source

Reference this value in your report via a card or similar.

This will give an approximate refresh time, as it actually only records the time at which this specific query was refreshed.

-2- Use the native refresh value provided in the dropdown at the top of the report in the Service:

This gives a more accurate refresh time, as it shows the time that the entire dataset completed its refresh.

Neither method will show only SCHEDULED refreshes. Rather both will show the date/time that ANY dataset refresh occurred, whether scheduled, pushed, or manual.

In order to be able to display just the set scheduled times, you *may* be able to use the URL of your refresh schedule page in the Service and use it as an HTML/web source. However, I've not tested this and may be fraught with authentication and formatting issues.

Either way, this also isn't going to give you an accurate representation of when a report was actually refreshed, due to MS load-balancing windows (+/- 15 mins) and actual processing time.

Pete

Pete