SBegum's avatar
SBegum
New Member
3 months ago

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

No RepliesBe the first to reply