Can anyone please let me know how can I display dataset's last refresh date of my power bi report? I want to display below date. I want this option on report, not on dashboard.
Create a new Blank Query, and then add this into the Advanced Editor:
Source = DateTimeZone.FixedUtcNow()
Then any time your report is refreshed, you'll be able to use this to show the date/time of the refresh.
UTCNOW() displays current UTC timing, whenever we open the report. But whenever a report is opened that does not mean dataset is refreshed. So I want to show last refresh time from dataset, which is shown below.
If you're in directquery mode, anytime you open the report in the Power BI service the query is refreshed
"When opening an existing report in the Power BI service, or authoring a new one, the underlying data source is again queried to retrieve the necessary data."
Below is the similar post for your reference.