Forum Discussion
tuulia
Helper IV
Helper IVTabular 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
amitchandak
Super User
Super Usertuulia , 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])
tuuliaHelper IV
Helper IVThank you, I think this is what I need. I just can't find the right solution to write mdx-query result to DW-table..