March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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 ReportingMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
24 | |
23 | |
12 | |
11 | |
8 |
User | Count |
---|---|
44 | |
44 | |
24 | |
12 | |
10 |