Forum Discussion
Community ChampionMicrosoft Fabric Capacity Metrics - Interactive Operation Failure details
Is it possible to get details about the failing operations (Highlighted in below screenshot) from capacity metrics
amitchandak GilbertQ Greg_Deckler lbendlin ibarrau Could you please help
8 Replies
- arvindsingh802
Thanks mohitkumawat, lbendlin for your response
Yes, I am intrested in the details of those failed queries so that I can work to get those optimised.
Have tried query trace from Dax Studio but its not possible to trace 24*7 with this approach and this happens only once or twice during the week so its hard to trace down- GilbertQ
Super User
There is a way to query the Capacity metrics data, it is complex but it can be done. You would need to use something like a notebook to query the data and then filter it for where the interactive queries have the status = failed.
- arvindsingh802
Thanks GilbertQ for suggetion, Could you please suggest any blog or document that I can refer for the same
- mohitkumawat
Impactful Individual
Hi arvindsingh802 .
As per Microsoft Doc We cannot se dirclty the Failed Status Because these occuer when CU usage counted if the capacity is in overload. otherwise you can check Azure Log Analytics For more Deeper Information.
- lbendlin
Can anyone actually confirm that log Analytics has that level of detail? I thought they only capture the query.
