last time refresh

[Anonymous]

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

[v-chuncz-msft]

@Anonymous,

You may also add a measure.

http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337

[Anonymous]

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?

[Anonymous]

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]

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 

[Anonymous]

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 🙂