Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tuulia
Helper IV
Helper IV

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)?

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@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])

View solution in original post

v-luwang-msft
Community Support
Community Support

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

View solution in original post

6 REPLIES 6
v-luwang-msft
Community Support
Community Support

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!

amitchandak
Super User
Super User

@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..

selimovd
Super User
Super User

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
 

Thank you, but it's not possible to use Power Query when PBI is connected "live" to tabular model..

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors