Forum Discussion
Last loading date display
Hi everyone, My report is almost complete but I still have a question : I would like to display the date of recording (from my database (Oracle), once a month). Is it possible to make a para...
go to Get data --> Blank Query
Goto Advanced Editor
Delete everything in there and replace it with this:
let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
in
SourceThis will give you a date and time everytime the report refreshes
Hi ! Thanks so much Anonymous !
It's working
but I don't know how to put it on my report
it's blank even if i've got the right information in my data
Thanks by advance,
Have a nice day !
Ok, I just find the solution, I created a new measure
LastRefreshDate = FORMAT(LASTDATE('Refresh'[LastRefresh]); "dd mmmm yyyy, hh:mm:ss")
and it's working ! :smileyvery-happy: