Extended information about Lakekehouse - Not admin of Fabric capacity

[MASFelixPBI]

Running Semantic link labs to get extended information for lakehouse tables I get an error that The 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' Id is not a valid capacity Id.

I assume that this is because I'm not admin on the specific capacity since on the workspace I see the message below

Please see the error codes below:

Error codes:

ValueError Traceback (most recent call last)
Cell In[19], line 4
1 lh = 'TBUS_LH_Enterprise_PRD'
2 ws = 'TB US Restaurant Insights'
----> 4 labs.lakehouse.get_lakehouse_tables(lakehouse= None, workspace=None, extended=True)

File /nfs4/pyenv-cd640a2e-c54f-41bc-a55e-4752aaec1075/lib/python3.10/site-packages/sempy/_utils/_log.py:348, in mds_log..get_wrapper..log_decorator_wrapper(*args, **kwargs)
345 start_time = time.perf_counter()
347 try:
--> 348 result = func(*args, **kwargs)
350 # The invocation for get_message_dict moves after the function
351 # so it can access the state after the method call
352 message.update(extractor.get_completion_message_dict(result, arg_dict))

File /nfs4/pyenv-cd640a2e-c54f-41bc-a55e-4752aaec1075/lib/python3.10/site-packages/sempy_labs/lakehouse/_get_lakehouse_tables.py:120, in get_lakehouse_tables(lakehouse, workspace, extended, count_rows, export)
117 df = pd.concat(dfs, ignore_index=True)
119 if extended:
--> 120 sku_value = get_sku_size(workspace)
121 guardrail = get_directlake_guardrails_for_sku(sku_value)
122 spark = SparkSession.builder.getOrCreate()

File /nfs4/pyenv-cd640a2e-c54f-41bc-a55e-4752aaec1075/lib/python3.10/site-packages/sempy_labs/directlake/_guardrails.py:60, in get_sku_size(workspace)
57 dfC_filt = dfC[dfC["Id"] == capacity_id]
59 if len(dfC_filt) == 0:
---> 60 raise ValueError(
61 f"{icons.red_dot} The '{capacity_id}' Id is not a valid capacity Id."
62 )
64 return dfC_filt["Sku"].iloc[0]

ValueError: 🔴 The 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' Id is not a valid capacity Id.

[m-kovalsky]

I don’t think you have to be an admin of the capacity. I think you just need access to the capacity.

Do you see it in this?

import sempy.fabric as fabric
fabric.list_capacities()

[MASFelixPBI]

With this code I can only see my trial capacity and PPU capacity.

[m-kovalsky]

So you don’t have proper access to see the capacity details).

[MASFelixPBI]

Maybe not checking everything correctly but how can I get the lakehouse information about table size row count withtout the extended capabilities?

[m-kovalsky]

Let me see if I can modify the function to still show extended details even if you have limited capacity access.

[MASFelixPBI]

Thank you, that would be a nice addition, even if we can't compare with the current capacity, if we are able to get the information about the tables would be a good piece of data.

[m-kovalsky]

Yeah, so the plan is to show the capacity stats if possible, if not just show None for those columns and populate the rest of the extended stats.