Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Date and Time
Report Server
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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: