Date/Time of last and previous update

[Anonymous]

Hi, is it possible to create a date and time for the last update and the previous update?
That means I'm producing the latest update date :
let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source

Next time I do an update I want to keep the current update time and create a new update date.
So there will always be the last two dates of the update.

It is possible?

[lbendlin]

No (*), and it is also meaningless. "Date Last Refreshed"  tells you nothing about the actual data. Power BI will happily refresh a stale dataset over and over again.

What you should be looking for is a "last modified date"  data point in your actual data,  and then you should use that in your report.

* You can get this via an API call. Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs  - but it is still not meaningful

[Anonymous]

@lbendlin 
My goal is to identify the data that was added between the date of the last update and the date of the penultimate update.
so I need two dates

[lbendlin · Accepted solution]

If that is the goal then you need to combine the API data with the Last Modified Date of your original data.

- Run a Power Query that fetches the date of the last successful refresh  (assuming that this is triggered by a new refresh request which will still be in flight and therefore not have an end date yet)

- compare that date to the Last Modified Date of your data.

Here is an example of the refresh history.  You need to handle the authentication (getting the token etc) yourself.

Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs