display dataset last refreshed date on the report

[Serge021]

When the dataset is set for scheduled refresh, how can you show on the report the last refresh data and time (highlighted below)?

Thanks

[sagarsankhe]

You can add a blank query on transformations. This expression is evaluated on every dataset refresh. So you can show the dataset refresh date time in your report using this table's column.

<Note: I added 8 hrs because I noticed Power BI service shows UTC date when it calculates the value on scheduled refreshes, so I am adding 8 hrs to get AWST timezone datetime value.>
let
Source = Table.FromValue(DateTime.LocalNow()+#duration(0,8,0,0))
in
Source

[v-jayw-msft · Accepted solution]

Hi @Serge021 ,

You could refer this document to create a column.

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops 

Best Regards,

Jay