Forum Discussion
refreshdate
It is probably because the query (that brings the time) was executed once you uploaded the report online.
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
Super UserA measure will always show the date/time of the moment when it was calculated (this means when you open the page in the report). So it is not the time of the refresh, it is time of the visual load on the page.
To get the actual refresh date time, you can follow this video: https://www.youtube.com/watch?v=oN6mOmEruOQ&ab_channel=GuyinaCube
Another thing to remember is that there can be a different timezone between your Notebook and the Service. So you might need to adjust the time by it.
I tried the video. The first ss shows the date on my report.
The 2nd ss shows after publishing report in BI workspace.