Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
is it possible to show the date from the last datasetupdate in a report?
Solved! Go to Solution.
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
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
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
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.
Proud to be a Super User!