Last loading date display

[Anonymous]

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 parameter or something ? 

And the same for the loading of my Excel files, I tried but I can't do it. 

If someone could give me some ideas ? 

Thanks by advance, 

Have a nice day !!

[Anonymous · Accepted solution]

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
Source

This will give you a date and time everytime the report refreshes

[Anonymous]

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 !

[Anonymous]

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 !