Forum Discussion
Solved
Tabular Model Last_data_update to Power BI
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...
tuulia , based on what I got. you need add the table and then you can get max using measure like
maxx(all(Table), [LAST_DATA_UPDATE])
Hi tuulia ,
The following article tells about how to extract data ,it may be helpful for you!
How to effectively extract data from an OLAP cube by relying upon T-SQL
Best Regards
Lucien
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:
How to Add the Last Refreshed Date and Time to a Power BI Report (enhansoft.com)
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Thank you, but it's not possible to use Power Query when PBI is connected "live" to tabular model..
