Find Which Semantic Models Use a Specific Database Table — Across All Workspaces
Ever needed to know which Power BI semantic models reference a specific source table before making a change or deprecating it?
This reusable Fabric Notebook scans all accessible workspaces in one run and identifies every semantic model that references your target table — no manual clicking required.
Key Features:
✅ Scans all workspaces in a single run
✅ Filter by workspace name keyword (e.g. [DEV] only)
✅ Three scan methods per model — datasources, model objects, and BIM/M query expressions
✅ Deduplicates results across scan methods
✅ Logs skipped models separately (permission errors)
✅ Export results to CSV in Lakehouse
Libraries used: semantic-link-labs, sempy.fabric
https%3A%2F%2Fgithub.com%2FBIWithSadia%2Fbi-toolkit%2Fblob%2Fmain%2FDB_table_across_all_workspaces.ipynb