get the latest refresh time from a table / partition of a semantic model

[AninoLocheDTX]

i want to have an overview of my tables of the model are refreshed. due to having a schedule for certain partition not all partitions are refreshed on the same time. now i need to look these up manually. only checking the refreshes is not sufficient. this because i refresh multiple tables / partitions in one run. so now i can only check if a run is failed or not.

i want a labs function where i can have as out put a list of tables and partitions with the latest refresh time per table / partition.

with this feature i can make a admin portal where i have an overview of tables that not refreshed lately.

[m-kovalsky]

You should be able to get this from running a dmv using semantic link’s evaluate_dax function.

$system.tmschema_partitions

[AninoLocheDTX]

perfect thanks! and thanks for developing semantic-link-labs, it really helps for new solutions!