DMV Views to Get Last Refreshed Date for Each Table and Last Refreshed Partitions

[abhiram342]

Hi Team,

We want to show the Last Refreshed Date for Each Table and Also, Latest Refreshed Partition for Fact Table ( Fact Table will have partitions). Can you please tell how to query DMV Views, I have explored DMV views using DAX Studio but unable to find this info.

Thanks,

Abhiram

[GilbertQ · Accepted solution]

Hi @abhiram342 

You can use this to get the table details:

select * from $SYSTEM.TMSCHEMA_TABLES

But for the individual partitions I am not sure that this is possible.