Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
16 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
1 |