Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.