Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

last time refresh

Hello,   i would like to insert a tile on my report with Last refreshed time (the time the report was refreshed from the source - it should be every 15 minutes). I have found several tips how to do...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

In a previous solution I created a simple table as part of the Power Query (Edit Queries) section of Power BI.  This table has 1 column and 1 row which contains the formula for the Date/Time of right now.

 

This will store the time and date of when the refresh is done, you can then display this on a tile. To do the same thing, do the following steps:

 

  • Click on 'Edit Queries' in the ribbon.
  • Select 'New Source' -> Blank Query
  • Name this new query as "Refresh Data"
  • Paste in the following code, and then select Close and Apply
let
    Source = #table({"Refresh DateTime"}, {{1}}),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Refresh DateTime", type datetime}}),
    SetRefreshTime = Table.ReplaceValue(#"Changed Type",#datetime(1899, 12, 31, 0, 0, 0),DateTime.LocalNow,Replacer.ReplaceValue,{"Refresh DateTime"})
in
    SetRefreshTime

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous

     

    thank you for your answer. However, I'm not able to add new data source, because I'm using DirectQuery Connection. Or am I missing something? 

    I use direct query because I need my report to update every 15 minutes from the data source. I connect to Azure SQL server. 

     

    P.S. I believe we work in the same company :smileywink:

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Anonymous  What i would try instead then, create a measure which is simply "Last Refresh = NOW()".  I'd think that would do what you expect. I don't work as much with Direct Query so i don't have a project on hand to test.  I'd be curious if that works.

       

      You should shoot me an internal hi at some point.  Always great to meet one of our own in the wild :)