Forum Discussion

nick1234's avatar
nick1234
Regular Visitor
1 year ago
Solved

Last Refreshdate with Tabular Editor 2 in a model deployed to SSAS Tabular Server

I have created my first model and it works very well with Tables, Relationships and Measures. I can make a Live connection to both Power BI as well as Excel so I am happy.    But one feature that I...
  • nick1234's avatar
    1 year ago

    The solution was way easier than I thought to begin with.

     

    1. Just add a new calculated table

    2. Select it and i the Expression Editor write: 

    ROW ( "Timestamp", FORMAT ( NOW (), "yyyy-mm-dd hh:mm:ss" ) )

     And when you save the model the Timestamp will appear in the Calculated tabel and be updated along with the other data in the model when the SSAS cube is processed.