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.