locked
Azure Analysis Services - Table Last Processed Date RRS feed

  • Question

  • I am trying to get the last processed date of all or a specific table in a Azure Analysis Services tabular model.  I have tried all the $System.MDSCHEMA  and $System.TBSCHEMA tables .  

    I have tried aka.ms/3SviJOX2, it works for on-premises AS  but not for Azure. 

    Any ideas? 

    Thanks


    Monday, May 13, 2019 3:57 PM

All replies

  • Hi Bpie7,

    You can try the Analysis Service DAX query as follows:

    SELECT * FROM $SYSTEM.DBSCHEMA_CUBES

    SELECT * FROM $SYSTEM.DBSCHEMA_TABLES

    For more details, refer “Finding the Last Processed Date for Analysis Services Cubes, measure Groups and Partitions”.

    Hope this helps. Do let us know if you any further queries.

    Tuesday, May 14, 2019 6:10 AM
  • Thanks for the response.  

    The first command should be SELECT * FROM $SYSTEM.MDSCHEMA_CUBES ,it does return a LAST_DATA_UPDATE column.  This column has the most recent date a table was processed.   

    The command SELECT * FROM $SYSTEM.DBSCHEMA_TABLES does not return a last processed date.   

    This is for a Tabular model in Analysis Services on Azure. 

    Tuesday, May 14, 2019 11:56 AM