Forum Discussion

New Member

9 years ago

Solved

Show Date from last Datasetupdate in Report

Hello,

is it possible to show the date from the last datasetupdate in a report?

Tips and Tricks

v-yulgu-msft
9 years ago
Hi cdietz,

You can add a custom column to data model using Power Query and then formatted the column as Date Time

Refresh date/time =DateTime.LocalNow()

For more details, please see:

Power BI – Create Last Dataset Refresh Date

Display Last Refreshed Date in Power BI

Best regards,
Yuliana Gu

3 Replies

kcantor
Community Champion
9 years ago
cdietz
I do a version of this by using LASTDATE in a measure.
Last Refresh = LASTDATE(Fact[OrderDate])
I also use Now()
Refresh Time = NOW()
It really depends on your needs and your tables.
v-yulgu-msft
Microsoft Employee
9 years ago
Hi cdietz,

You can add a custom column to data model using Power Query and then formatted the column as Date Time

Refresh date/time =DateTime.LocalNow()

For more details, please see:

Power BI – Create Last Dataset Refresh Date

Display Last Refreshed Date in Power BI

Best regards,
Yuliana Gu
v-yulgu-msft
Microsoft Employee
9 years ago
Hi cdietz,

Have you worked it out? If so, would you please kindly mark the helpful reply as an answer or sharing your solution?

Regards,
Yuliana Gu