Forum Discussion

danielkataoka's avatar
danielkataoka
Frequent Visitor
9 months ago
Solved

Fabric Capacity Metrics - Dataset Refresh Count

Hi. Is it possible to view the count of dataset updates? I'm trying to use the count_operations in the MetricsByItemandOperationandDay but its not working.  Also, I'm filtering the record Datase...
  • Anonymous's avatar
    Anonymous
    9 months ago

    Hi danielkataoka ,

     

    Thank you for reaching out to the Microsoft Fabric Community Forum. Thank you DataVitalizer and DataVitalizer  for your response.

     

    The MetricsByItemAndOperationAndDay view is a daily summary, so it will always return a single row per dataset per day, with the timestamp set to 00:00:00. This is why you only see one record even if the dataset refreshes multiple times.

    To view each refresh attempt (including retries) with the actual timestamp, you’ll need to use a more granular view such as MetricsByOperation or MetricsByOperationAndItem. These tables record every operation event and will allow you to count refreshes correctly.

    If this does not resolve the issue, please share which metrics tables are available in your capacity.

     

    Thank you.