Forum Discussion
Power ParticipantHow to include the 'Latest Refresh' date and time in a report?
In the main PowerBI window, in the Home ribbon:
Get Data => Blank Query
A new window should open (Query Editor), within that window go to the Home ribbon then Advanced Editor
A new window will open with the code like this
let Source = "" in Sourcereplace it with the one I posted before, click Done, then Close & Apply
Community Championyou can create a new table in M, that when loaded to the model will give you the refresh time, e.g. like this
let
Source = #table({"Last refresh"}, {{DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())}}),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Last refresh", type datetime}})
in
#"Changed Type"
AliceWHi Stachu,
How do I create that table? Do I use the 'Enter Data' button? Where do I enter the formula you've provided?
Thanks!!
- AliceW
I've also tried 'New table' in the Modelling tab, but I get an error
- Stachu
In the main PowerBI window, in the Home ribbon:
Get Data => Blank Query
A new window should open (Query Editor), within that window go to the Home ribbon then Advanced Editor
A new window will open with the code like this
let Source = "" in Sourcereplace it with the one I posted before, click Done, then Close & Apply