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.
How do I set up the query editor in m language to create a column that will show me the last refresh date of the source data?
Solved! Go to Solution.
You may use DateTime functions.
DateTime.LocalNow()
You may use DateTime functions.
DateTime.LocalNow()
Did you find a resolution to this yet? This is what I've been doing, but I'm interested to know if there is a better (more straightforward) way.
1.) Depending on the data source, I've been creating a new datetime column at the source to get the current timestamp. This can be included in an existing query or as a new query in the PBI Query Editor.
2.) On the PBI Desktop, I create a new measure to return that current timestamp. For example,
Last Refresh = "Last Refresh : " & LASTDATE('PBI_LAST_REFRESH_DATE'[REFRESH_DATE])
3.) On the canvas, I use a standard Card visual to display the value of that measure.
When the data source is refreshed, then the current timestamp column is recalculated at the source & re-imported into PBI.
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.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |