Forum Discussion
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 [LAST_DATA_UPDATE]
FROM $System.MDSCHEMA_CUBES
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)?
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
6 Replies
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicThank you, but it's not possible to use Power Query when PBI is connected "live" to tabular model..
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])
Thank you, I think this is what I need. I just can't find the right solution to write mdx-query result to DW-table..
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
Thank you, this is very useful!
