Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, Community!
Our organization has just started to use Lakehouses in Fabric: both centrally by Group It and on the business side.
In the MS Fabric Capacity Metrics report, I notice, that there's 1 business user workspace, that takes up over 60% of our capacity storage - 3 times as much as our own IT lakehouse storage. Please, see the picture.
The Fabric Capacity Metrix report does not specify, which items in the workspace take most capacity - or does it?
So, my question is: what does potentially take so much capacity: Lakehouses, notebooks, somethings else? How can I dig deeper to find out?
Many thanx in advance!
Solved! Go to Solution.
Hi @Alisea_MI
You could use this from Michael at the Power BI Team to get a list of the Table and their sizes fabric_cat_tools/Model Optimization.ipynb at main · m-kovalsky/fabric_cat_tools · GitHub
And then use this in a notebook.
# Install Fabric CAT Tools
%pip install "https://raw.githubusercontent.com/m-kovalsky/fabric_cat_tools/main/fabric_cat_tools-0.3.0-py3-none-any.whl"
import fabric_cat_tools as fct
df = fct.get_lakehouse_tables(
extended = True
)
display(df)
Many thanx, @GilbertQ ! I will definitely give it a try - unfortunately did not manage to find time this week.
Hi @Alisea_MI
You could use this from Michael at the Power BI Team to get a list of the Table and their sizes fabric_cat_tools/Model Optimization.ipynb at main · m-kovalsky/fabric_cat_tools · GitHub
And then use this in a notebook.
# Install Fabric CAT Tools
%pip install "https://raw.githubusercontent.com/m-kovalsky/fabric_cat_tools/main/fabric_cat_tools-0.3.0-py3-none-any.whl"
import fabric_cat_tools as fct
df = fct.get_lakehouse_tables(
extended = True
)
display(df)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.