Hi! How can I display the last refresh-date/time of SSAS tabular model in Power BI-report?
This query from model returns the correct result, but how can I make a measure from it:
SELECT TOP 1 [LAST_DATA_UPDATE]
WHERE [catalog_name] = 'my_model_name'
ORDER BY [LAST_DATA_UPDATE] DESC
Is there a way to create this "measure" in model or do I have to write the result of the query to SQL Server table first (and how to do it)?
Solved! Go to Solution.
Hey @tuulia ,
I would recommend to do that in Power Query. Like this whenever the data model is refreshed also the date and time is refreshed, so the user can see the real date/time of the last refresh.
Follow the first approach in the following article: