Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Mabasile_MSFT

Understand your storage with OneLake item-size reporting (Preview)

Author: Matt Basile - Senior Product Manager

 

More data means more insights, more analytics, and more context for AI, but also more concerns.  When your monthly storage bill exceeds expectations, what’s your next step? How do you identify where that excess data is stored, and what actions you can take?

OneLake item-size reporting (Preview) is designed to provide workspace administrators with item-level insight into storage usage across OneLake, including system and soft-deleted data. With the new storage report, you can better understand and manage your OneLake storage consumption.
 

 

The storage report summarizes storage sizes across all itemsThe storage report summarizes storage sizes across all items

 

Previously, getting an item-level storage breakdown could be challenging. The Capacity Metrics app shows the total amount of data in your workspace, while tools like Azure Storage Explorer support manual investigation but can't aggregate system data. 

OneLake item-size reporting helps address this gap by calculating item sizes across OneLake, including system and soft-deleted data, with a unified report and straightforward refresh.
 

What is OneLake item-size reporting?

Item-size reporting introduces a dedicated page in your workspace's settings. From this page, you and other workspace admins have the following capabilities:

  • View the most recent report or refresh for updated data.
  • Explore how item storage breaks down across visible, hidden, and soft-deleted data. 
  • Sort and search the report to help identify items with higher storage usage.

 

OneLake calculates the item sizes whenever you initiate a report refresh, with runtime and CU consumption varying with workspace size and other characteristics. To minimize repeated scans from multiple refreshes, OneLake also caches the report results. Once the report is aggregated, any workspace admin can view the results without initiating another refresh. 

 

Although you can achieve similar functionality by manually scanning and aggregating the data yourself, item-size reporting helps to streamline storage analysis and provide a more consistent view of your data.  Because data is automatically aggregated to the item, OneLake can scan the entire item, including hidden system folders used by workloads to store metadata, temporary files, or other workload-specific data. With item-size reporting, you can know at a glance where your data stored, helping you make informed decisions to manage your data.

 

Get started

To generate your first OneLake storage report:

  1. Open your workspace in the Fabric portal - you must be a workspace admin.
  2. Go to Workspace settings > OneLake > Storage report
  3. Select "Refresh".
  4. Once the report is refreshed, explore your new item-size report!

 

With item-level reporting in OneLake, you can feel confident managing your items and growing your data estate. To learn more, check out Get the size of OneLake items.

Comments