I am proposing a small improvement to the "Partitions & policies" and "Tooltip-Table" pages to improve the visibility of partitions which were never refreshed and also ability to only select such partitions.
In case the partition was never refreshed, instead of showing default date in the table-partition tooltip:
show some sort of indicator that it was never refreshed similar to as SSMS shows:
we could show something like this:
A possible implementation could be to use a custom measure for "refreshed Time" instead of the column:
{Slctd} refreshed Time = IF ( ISBLANK ( SELECTEDVALUE ( Partitions[state] ) ), "Never", FORMAT ( SELECTEDVALUE ( Partitions[refreshed Time] ), "dd.mmm.yyyy hh:nn" ) )
Additional slicer in the "Partitions & policies" would also help to filter only the partitions which were never refreshed (could use the original partition state column):
For the slicer to work properly, we would need to filter table visual accordingly, as the Table Name and and Partition State are coming from different tables. This could be done simply by putting "# Partitions" measure in the visual level filters and applying "Is not blank" filter.
Hi,
I am proposing a small improvement to the "Partitions & policies" and "Tooltip-Table" pages to improve the visibility of partitions which were never refreshed and also ability to only select such partitions.
In case the partition was never refreshed, instead of showing default date in the table-partition tooltip:
show some sort of indicator that it was never refreshed similar to as SSMS shows:
we could show something like this:
A possible implementation could be to use a custom measure for "refreshed Time" instead of the column:
{Slctd} refreshed Time = IF ( ISBLANK ( SELECTEDVALUE ( Partitions[state] ) ), "Never", FORMAT ( SELECTEDVALUE ( Partitions[refreshed Time] ), "dd.mmm.yyyy hh:nn" ) )Additional slicer in the "Partitions & policies" would also help to filter only the partitions which were never refreshed (could use the original partition state column):
For the slicer to work properly, we would need to filter table visual accordingly, as the Table Name and and Partition State are coming from different tables. This could be done simply by putting "# Partitions" measure in the visual level filters and applying "Is not blank" filter.
Thanks :)