Create a Last Refreshed Timestamp within Power BI using Power Query & DAX

In this quick video, we'll be using the advanced editor & M code within Power Query to display a date & time for the last refresh of our Power BI Report.
We'll then use nested DAX functions to format our last refreshed time and create a well formatted Card that can be build into a Professional looking Report.
The Power BI Tenant runs on UTC, when this solutions runs on the Service the refresh time may become offset. However, there are ways around it that I didn't want to cover in the interest of keeping the video short:
Ed Hansberry showcases a longer M code with DST Offset:
www.ehansalyti...
If you're using an on prem SQL database: You can use GETDATE() & MIN/ MAX Measures
Within Power BI: You could create an offset reference table
🤝 Visit my Website:
www.matadorsof...
🤝 Connect with me on LinkedIn:
/ ja376
Please Like, Subscribe, Comment & Share if you enjoy!

[@ExcelWithChris]

Thankx, but what if the refreshing happens online, how do I get the date and time from when it happened on the BI server?

[@swatichauhan3802]

Great video, Big Help.. Thank you. Could you please provide the hex code for Background color and Green one too.

[@susantakumar8330]

Learning something new. Thanks for sharing.

[@MatadorSoftware]

It’s my pleasure, glad you found it helpful!

[@CarlosCruz-zu8bw]

Great video ! Thanks

[@MatadorSoftware]

Cheers Carlos, my pleasure!

[@silverardorcreations78]

What about if thE Report is via a live connection?

[@MatadorSoftware]

If you're using an on prem SQL database: You can use GETDATE() & MIN/ MAX Measures

[@texmexdragon2160]

@@MatadorSoftware Our source data is coming from dataflows (not on prem). My understanding is that it is not possible to get a last refresh date to work when the report is connected to the dataset via live connection

[@MatadorSoftware]

@@texmexdragon2160 community.powerbi.com/t5/Desktop/Dataflows-Last-Refresh-Date/td-p/678749 There’s a solution within the Power BI forums

[@EnneagramTarot-zu8kp]

Nice dashboard! Also curious how this works with publishing to the service.