Forum Discussion
Power BI - Fabric Capacity Metrics
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-consumptionHope this helps. If you have any questions regarding this, please feel free to reach out to us. We will be happy to help.
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.
Hi,
Still the issue is not resolved.
I am unable to find the file storage location from the power bi capactiy report.
need more help
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-consumptionHope this helps. If you have any questions regarding this, please feel free to reach out to us. We will be happy to help.
Hi girishtharwani2,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
Hi girishtharwani2,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.