Optimising Fabric Capacity Usage

Hi FabricEnjoyer​,

Thank you for reaching out to Microsoft Fabric Community.

The CU consumption depends on the workload, so there is no general rule that materializing every sql view into delta tables will reduce capacity usage.

If the existing sql views are already optimized, I would recommend keeping the current approach rather than moving all the logic to notebooks just to reduce sql consumption. Materializing the views is useful when the same transformation is expensive and reused frequently, but the notebook execution and maintenance also consume fabric capacity.

Use the Capacity Metrics app to identify whether semantic model refreshes or direct queries from excel and other users are causing most of the consumption before changing the architecture.

Thanks and regards,
Anjan Kumar Chippa