The Fabric Capacity Metrics App currently retains data (Item History, CU% over time, CU by workspace, etc.) only for the past one month, which limits long-term analysis. To effectively track optimization progress, capacity trends, and governance metrics, customers need access to historical consumption data over longer periods. Instead of extending the built-in timeframe, the idea is to introduce a connector that exposes capacity metrics so customers can store and analyze historical data in their own storage units (e.g. Lakehouse, SQL DB or Data Warehouse). The connector doesn’t need to expose all data available in the Fabric Capacity Metrics App — it could simply provide key summarized metrics sufficient to deliver insights into capacity consumption trends over time across various factors. This would enable organizations to create custom dashboards and reports for multi-month trend analysis, capacity forecasting, and optimization tracking, greatly improving administration and governance of Fabric capacities. A similar approach to the Azure Cost Management connector, which enables users to extract and store cost data for custom and long-term analysis, would be highly valuable for Fabric Capacity Metrics as well.
... View more