query editor last date refresh

krzysztof — Thu, 04 Oct 2018 15:48:56 GMT

How do I set up the query editor in m language to create a column that will show me the last refresh date of the source data?

Re: query editor last date refresh

jshutters — Thu, 04 Oct 2018 20:50:21 GMT

Did you find a resolution to this yet? This is what I've been doing, but I'm interested to know if there is a better (more straightforward) way.

1.) Depending on the data source, I've been creating a new datetime column at the source to get the current timestamp. This can be included in an existing query or as a new query in the PBI Query Editor.

2.) On the PBI Desktop, I create a new measure to return that current timestamp. For example,

Last Refresh = "Last Refresh : " & LASTDATE('PBI_LAST_REFRESH_DATE'[REFRESH_DATE])

3.) On the canvas, I use a standard Card visual to display the value of that measure.

When the data source is refreshed, then the current timestamp column is recalculated at the source & re-imported into PBI.

Re: query editor last date refresh

v-chuncz-msft — Tue, 09 Oct 2018 09:05:35 GMT

@krzysztof,

You may use DateTime functions.

DateTime.LocalNow()

topic query editor last date refresh in Developer

query editor last date refresh

Re: query editor last date refresh

Re: query editor last date refresh