How Long Does It Take for Azure Fabric Capacity Metric App to show Metrics

[carlton7372]

Hi Community,

I have been doing a LOT of work with the Azure Fabric Capacity Metrics App, or should I say with Fabric semantic model on Power BI Desktop.

I have submitted a number of jobs/queries to Workspace that it monitored by the Metrics App. I have waited over an hour for the metrics to appear in the App, but never appears. I have run a couple DAX queries (with the help of ChatGPT) against the Fabric Metrics model so query the model for a particular job run called 'Refactored_DB_Refresh' see below, but no metrics appear.

Can someone let me know exactly how long it takes for metrics to appear.

The puzzling thing is the metrics that appear in app were jobs that were run yesterday, 15th October 2025, but appears being run today - I really don't understand

The following is DAX query that I ran against the Fabric Metrics semantic model, which is searching for a job I executed in the last 2 hours, but it still isn't appearing Fabric Metrics App.

// Per-item totals in the last 24 hours for Item kind = "Refactored_DB_Refresh"
DEFINE
  VAR _Kind = "Refactored_DB_Refresh"

  // Create a table filter from a VAR safely (ROW works with variables)
  VAR _KindFilter =
    TREATAS ( ROW ( "Item kind", _Kind ), Items[Item kind] )

  // Anchor on latest timestamp in the hourly autoscale fact
  VAR _LastTs =
    CALCULATE (
      MAX ( 'Metrics By Item And Hour For Workload Autoscale'[Datetime] ),
      REMOVEFILTERS ( 'Metrics By Item And Hour For Workload Autoscale' )
    )

  // Rolling 24h window
  VAR _Last24h =
    FILTER (
      ALL ( 'Metrics By Item And Hour For Workload Autoscale'[Datetime] ),
      'Metrics By Item And Hour For Workload Autoscale'[Datetime] >= _LastTs - 1
        && 'Metrics By Item And Hour For Workload Autoscale'[Datetime] <= _LastTs
    )

  // Query-scoped measures
  MEASURE 'Metrics By Item And Hour For Workload Autoscale'[CU (s) _Q] =
    SUM ( 'Metrics By Item And Hour For Workload Autoscale'[CU (s)] )

  MEASURE 'Metrics By Item And Hour For Workload Autoscale'[Duration (s) _Q] =
    SUM ( 'Metrics By Item And Hour For Workload Autoscale'[Duration (s)] )

EVALUATE
  ADDCOLUMNS (
    SUMMARIZECOLUMNS (
      Items[Item name],
      _Last24h,
      _KindFilter          // robust filter—no scalar ambiguity
    ),
    "CU (s) last 24h",       [CU (s) _Q],
    "Duration (s) last 24h", [Duration (s) _Q],
    "Window Start",          _LastTs - 1,
    "Window End",            _LastTs
  )
ORDER BY [CU (s) last 24h] DESC, Items[Item name]

The output is a follows... as you can see there is nothing. 

I hope someone can help with this because it's driving me crazy 🙂

[tayloramy · Accepted solution]

Hi @carlton7372, 

For existing items, it usually takes around 15 minutes for data to flow, however new items don't appear until the capacity metrics semantic model is refreshed. 

Remember that capacity metrics is in UCT time unless the Fabric Admin sets a UTC offset in the semantic model parameters. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.