Power BI - Fabric Capacity Metrics

Hi girishtharwani2 ,

Based on your screen shot i can understand you are seeing the storage details of the worksapces.

There are few things we need to consider here while checking storage:

1) This is complete OneLake storage GB which is shown here based on the number of workspaces created.

2) The above information comes from STorage page, read the COMPUTE page to identify the Fabric items like warehouse/lakehouse/KQL DB/SQL DB CU consumptions, to identify the mroe usage.

YOu can also check the othwr charts and graphs on the compute page to check how many reads/writes are happening in lakehouse/warehouse and in another storage. The item which consumes more CU's check if its a write operation, more writes means more table data is getting loaded. 

3) Check notebook CUs on compute page, is there any notebook which writing into tables, thereby adding to more storage.

The main idea is to check the compute page to identify usage of storage.

Let me know if it helps, please give kudos if you like my response and consider it as a solution if it works for you.

Thanks

Ati Puri

Hi girishtharwani2 ,

another option would be to use FUAM.
It’s not an official Microsoft product, but it provides detailed information on all Fabric settings as well as the individual workspaces.

Here’s the link to the GitHub repository. It’s now part of the Fabric Toolbox.

https://github.com/microsoft/fabric-toolbox/tree/main/monitoring/fabric-unified-admin-monitoring

I can also recommend Fabric Jumpstart; there you'll find a few ready-made solutions that might help you.

Here is the link to Fabric Jumpstart.

https://jumpstart.fabric.microsoft.com/

I use it myself to monitor my capacity in general.

https://jumpstart.fabric.microsoft.com/catalog/fpm-capacity-events/

I hope that helps.

Many greetz

spaceman127

Feel free to leave kudos or accept it as a solution. This will also help other community members.

Hey  

To discover high GB consumption in the Fabric Capacity Metrics app, follow these steps: 

• Assess the Storage Page in Capacity Metrics App 
• Discover the High-Consuming Workspace 
• Drill Down by Experience and Item Type 
• Check Trends Over Time 

  This approach will help you spot and optimize storage consumption.  

Hi girishtharwani2, 

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to spaceman127, alicegray, ati_puri,  for those inputs on this thread.

Has your issue been resolved? If the response provided by the community member spaceman127, alicegray, ati_puri,  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.