locked
How to get the model last refresh date using dax query RRS feed

  • Question

  • I want to show on the dashboard the last refresh date for the model so that the users will get this info.how to show this using a dax query
    Saturday, January 21, 2017 3:56 AM

Answers

  • Hello,

    AFAIK there is no DAX command available to get the last update timestamp, you can only try to query it form PP DMV's, see Query Power Pivot DMVs with VBA for an example.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Abhishek_300 Tuesday, January 24, 2017 12:42 PM
    Sunday, January 22, 2017 7:52 AM
  • Hi Abhishek_300,

    Thanks for your question.

    As Olaf said, we cannot get the last refresh date using a simple DAX query. However, There are many other ways to get this information. You can use the metadata provided by XMLA or DMV, just as you can do in SSAS Multidimensional. Or you can use a calculated column that contains the DAX expression NOW().

    For more detail, please refer to Last Process Date in SSAS Tabular .


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by alexander fun Tuesday, January 24, 2017 11:53 AM
    • Marked as answer by Abhishek_300 Tuesday, January 24, 2017 12:42 PM
    Monday, January 23, 2017 5:55 AM

All replies

  • Hello,

    AFAIK there is no DAX command available to get the last update timestamp, you can only try to query it form PP DMV's, see Query Power Pivot DMVs with VBA for an example.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Abhishek_300 Tuesday, January 24, 2017 12:42 PM
    Sunday, January 22, 2017 7:52 AM
  • Hi Abhishek_300,

    Thanks for your question.

    As Olaf said, we cannot get the last refresh date using a simple DAX query. However, There are many other ways to get this information. You can use the metadata provided by XMLA or DMV, just as you can do in SSAS Multidimensional. Or you can use a calculated column that contains the DAX expression NOW().

    For more detail, please refer to Last Process Date in SSAS Tabular .


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by alexander fun Tuesday, January 24, 2017 11:53 AM
    • Marked as answer by Abhishek_300 Tuesday, January 24, 2017 12:42 PM
    Monday, January 23, 2017 5:55 AM