topic Re: Last loading date display in Report Server

Last loading date display

Anonymous — Tue, 07 May 2019 08:23:40 GMT

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 — Wed, 08 May 2019 06:57:48 GMT

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 — Thu, 09 May 2019 08:45:27 GMT

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 — Thu, 09 May 2019 08:50:34 GMT

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: