Forum Discussion
Fabric Monitor to KQL Database
I don't think we are able to directly access the Kusto database which is behind the Fabric capacity metrics app (FCMA).
I think we would need to query the data from the Fabric capacity metrics app's semantic model (using the DAX query API or semantic link), and save it in our own storage (e.g. Lakehouse or KQL). There are some solutions on the web that shows examples of how to do this. Please note, the schema of the FCMA semantic model may change, so such a solution would need to be adjusted on your side if the semantic model is changed by Microsoft.
Fabric Workspace Monitoring is another monitoring tool (currently in preview) which creates a Kusto dabase in each workspace it gets activated in. This one is easily to connect to. But at the moment it only captures Semantic model, Eventhouse and GraphQL events.
Thanks for the reply. I only need to know where the data is (which Kusto database). Would this be something hidden to non-admins?
Super UserIt's hidden and Microsoft are extremely tight-lipped about it. They are also not answering any questions about the atrocious 8 minute delay of their "real time" data.
Thanks again for your answer. I have a feeling it may be in the Admin Workspace. Really helps knowing that it's a Kusto database.
- lbendlin
Yes, if you put it in a premium workspace (which is a whole 'nother story to get wound up about) you can connect to the semantic model and do your own reports like this one
frithjof_vCommunity Champion
I don't think we are able to directly access the Kusto database which is behind the Fabric capacity metrics app (FCMA).
I think we would need to query the data from the Fabric capacity metrics app's semantic model (using the DAX query API or semantic link), and save it in our own storage (e.g. Lakehouse or KQL). There are some solutions on the web that shows examples of how to do this. Please note, the schema of the FCMA semantic model may change, so such a solution would need to be adjusted on your side if the semantic model is changed by Microsoft.
Fabric Workspace Monitoring is another monitoring tool (currently in preview) which creates a Kusto dabase in each workspace it gets activated in. This one is easily to connect to. But at the moment it only captures Semantic model, Eventhouse and GraphQL events.