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:
ehansalytics.com/blog/2020/7/29/add-a-refresh-time-stamp-to-your-power-bi-reports
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:
matadorsoftware.me/
🤝 Connect with me on LinkedIn:
linkedin.com/in/ja376
Please Like, Subscribe, Comment & Share if you enjoy!
- Create a Last Refreshed Timestamp within Power BI using Power Query & DAX ( Download)
- How do you get a REFRESH DATE in your Power BI report ( Download)
- How to Add Last Refresh Date & Time in PowerBI | MiTutorials ( Download)
- Issue with Last Refresh Date/Time in Power BI ( Download)
- Change Time zone in Last Refresh Date in PowerBi | MiTutorials ( Download)
- Creating a Last Refreshed Time Stamp in Power BI ( Download)
- How to Add the Last Refreshed Date to Power BI Reports ( Download)
- Last REFRESH DATE in Power BI (Power Query) ( Download)
- The ultimate TIME STAMP in Power BI | UTC and Daylight Saving Time FIX ( Download)
- Create Last Refresh Time that respects Daylight Saving in Power Query ( Download)
- Showing LAST REFRESH in Power BI #Shorts ( Download)
- Showing Specific Timezones in Power BI Service (Last Refreshed Time) ( Download)
- Get Updated Last Refresh Date And Time In Power BI ( Download)
- Last Refreshed in POWER BI (Desktop + Service) ( Download)
- DATE TABLE for Power BI using Power Query ( Download)
