Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello everyone!
I have a report that updates automatically every day first thing in the morning.
Is it possible to extract the updated date (Dados atualizados) below to display it in a card visual?
First I tried to create a new table using
Last Refresh Date = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
But the code only works when I update the report manually through Power Bi Desktop.
Any idea how to solve this?
Best regards,
Hi @gdps_vc - I wrote a blog article on how to do this, including accounting for daylight saving time. Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics
That time stamp that is captured can then be added to a card visual. I do that with almost all of my reports.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCheck out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.