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 it, but all of them use custom column or new data source.

 

I use Direct Query mode, so I cant modify column and add new sources. Is there a way how to do it anyway? 

 

Thank you,

Markéta

Need Help

5 Replies

    • 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 v-chuncz-msft

       

      thank you for answer. But i need date when PowerBi refreshed dataset from Azure SQL. This will show me the time now (or the last refresh of the browser), am I right?