Fabric Shortcut Inventory

A Microsoft Fabric notebook that scans workspaces and builds a complete inventory of OneLake shortcuts, detecting orphaned, circular and ungoverned external shortcuts, with an interactive HTML report and optional persistence to a Delta table.

OneLake shortcuts are easy to create and hard to govern: over time you accumulate shortcuts pointing to deleted items, circular chains between lakehouses, and connections to external storage (S3, ADLS, GCS…) with no sensitivity label or endorsement whatsoever. Fabric offers no centralized view of any of this. This notebook builds one in a single run.

1. Discovers workspaces — the entire tenant (with admin permissions) or a specific list, by name or ID.
2. Discovers items — lists the items in each workspace via the Fabric REST API.
3. Extracts shortcuts — in parallel, from the item types that support them (Lakehouse, KQL Database, Mirrored Database).
4. Parses targets — normalizes OneLake targets (workspace/item/path) and external ones (Amazon S3, ADLS Gen2, Google Cloud Storage, S3 compatible, Dataverse, Azure Blob Storage, OneDrive/SharePoint).
5. Validates:
   • Orphaned: the target item no longer exists within the scanned scope.
   • Circular: shortcut chains that form a cycle (DFS detection over the dependency graph).
   • Governance: external shortcuts on items with no sensitivity label and no endorsement (Certified/Promoted).
6. Resolves names — turns target GUIDs into human-readable names, even for targets outside the scanned scope.
7. Presents — an interactive HTML report with 4 views (Overview, Circular, Orphan, Governance) and per-row color coding.
8. Persists (optional) — writes the inventory to a Delta table so you can query it with SQL or build Power BI reports on top

All the code and documentation can be found in the Github Repository.

https%3A%2F%2Fgithub.com%2Fkilianbs%2Ffabric-shortcut-inventory%2Fblob%2Fmain%2Fshortcut_inventory_en.ipynb