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:
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.