Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
i've got a list of tables in my Lakehouse using API and the response is as below.
however, there are needs to identify what are the shortcut tables. also view tables are need to be shown in the list.
i know there is Get shortcut API(https://learn.microsoft.com/en-us/rest/api/fabric/core/onelake-shortcuts/get-shortcut?tabs=HTTP#shor...) but i am not sure how to use it in my case,,,
is anyone please help?
Best regards
{
"continuationToken": "+RID:~HTsuAOseYicH-GcAAAAAAA==#RT:1#TRC:1#ISV:2#IEO:65567#QCF:8#FPC:AgKfAZ8BnwEEAAe8eoA=",
"continuationUri": "https://api.fabric.microsoft.com/v1/workspaces/f089354e-8366-4e18-aea3-4cb4a3a50b48/lakehouses/41ce0...",
"data": [
{
"type": "Managed",
"name": "Table1",
"location": "abfss://f089354e-8366-4e18-aea3-4cb4a3a50b48@onelake.dfs.fabric.microsoft.com/41ce06d1-d81b-4ea0-bc6d-2ce3dd2f8e87/Tables/Table1",
"format": "Delta"
}
]
}
Solved! Go to Solution.
Hi @jwryu
You’re correct that the List Tables API response doesn’t include view tables or detailed properties like whether a table is a shortcut. To address your needs, you’ll need to use a combination of APIs and potentially some additional processing. Here’s how you can approach this:
1. For shortcut tables:
• Use the Get Shortcut API for each table in your list to determine if it’s a shortcut.
https://learn.microsoft.com/en-us/rest/api/fabric/core/onelake-shortcuts/get-shortcut
• You’ll need to make separate API calls for each table, using the workspace ID, item ID (Lakehouse ID), and table name.
2. For view tables:
• Unfortunately, the current List Tables API doesn’t include view tables in its response.
• You might need to use a different approach, such as querying the Lakehouse directly using SQL, to get a complete list including views.
3. To combine this information:
• Start with the List Tables API to get your initial list.
https://learn.microsoft.com/en-us/rest/api/fabric/lakehouse/tables
• For each table, make a Get Shortcut API call to check if it’s a shortcut.
• Use a separate method (like SQL querying) to get view tables and merge this information with your list.
please give kudos and accept the solution if this is helpful.
thanks
Hi @jwryu
You’re correct that the List Tables API response doesn’t include view tables or detailed properties like whether a table is a shortcut. To address your needs, you’ll need to use a combination of APIs and potentially some additional processing. Here’s how you can approach this:
1. For shortcut tables:
• Use the Get Shortcut API for each table in your list to determine if it’s a shortcut.
https://learn.microsoft.com/en-us/rest/api/fabric/core/onelake-shortcuts/get-shortcut
• You’ll need to make separate API calls for each table, using the workspace ID, item ID (Lakehouse ID), and table name.
2. For view tables:
• Unfortunately, the current List Tables API doesn’t include view tables in its response.
• You might need to use a different approach, such as querying the Lakehouse directly using SQL, to get a complete list including views.
3. To combine this information:
• Start with the List Tables API to get your initial list.
https://learn.microsoft.com/en-us/rest/api/fabric/lakehouse/tables
• For each table, make a Get Shortcut API call to check if it’s a shortcut.
• Use a separate method (like SQL querying) to get view tables and merge this information with your list.
please give kudos and accept the solution if this is helpful.
thanks
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.
User | Count |
---|---|
55 | |
27 | |
18 | |
10 | |
4 |
User | Count |
---|---|
71 | |
67 | |
21 | |
8 | |
6 |