Forum Discussion

girishtharwani2's avatar
girishtharwani2
Helper III
2 months ago
Solved

Power BI - Fabric Capacity Metrics

Hi, We are using the Power BI - Fabric Capacity Metrics And in one of the workspace it says we have consumed more GB. How to check the details of it and where exactly it is consumed.     ...
data engineering
data pipeline
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    2 months ago

    Hi girishtharwani2, 
    Thank you for the follow-up question.

    The Fabric Capacity Metrics app only shows storage consumption at the workspace level and does not provide a drill-down to the exact file or table consuming the storage. This is why you're unable to identify the specific source of the 500 GB usage from the Capacity Metrics report alone.

    To identify the storage consumer, navigate to Workspace Settings → One Lake → Storage report (Preview). The Storage Report provides item-level storage details and can help you determine which Lakehouse, Warehouse, Semantic Model, Mirrored Database, or other Fabric item is consuming the most storage within the workspace.

    If you need more granular details, open the identified item and review its tables, files, historical data, shortcuts, or mirrored data, as the Storage Report may not always provide a file-level or table-level breakdown.

    Refer these links:
    1. https://learn.microsoft.com/en-gb/fabric/enterprise/metrics-app-storage-page 
    2. https://learn.microsoft.com/en-gb/fabric/onelake/how-to-get-item-size 
    3. https://learn.microsoft.com/en-gb/fabric/onelake/onelake-consumption 

    Hope this helps. If you have any questions regarding this, please feel free to reach out to us. We will be happy to help.

spaceman127's avatar
spaceman127
Super User
2 months ago

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.