Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

refreshdate

I want to use refreshdate measure to find out when my model refreshed last time. I used LastrefreshDate=Now() the time it shows me ands the time which I get after publishing my report are different...
  • zenisekd's avatar
    1 year ago

    It is probably because the query (that brings the time) was executed once you uploaded the report online. 

  • Tutu_in_YYC's avatar
    1 year ago

    instead of using DAX, which recalculates when you interact with the report, you need to implement it in power query using the following:

    https://learn.microsoft.com/en-us/powerquery-m/datetime-localnow

    This will return you the time the query is refreshed. Just note that you need to adjust to your timezone, as this function returns date time in UTC