Semantic Model Audit 08-01-2025 10:49 AM - last edited 08-03-2025 18:28 PM

[justinmartin]

Link to Notebook 

Overview

This tool is designed to provide a comprehensive audit of your Fabric semantic models.

Key Features

1. Model Object & Metadata Capture:

   • Retrieves and standardizes the latest columns and measures using Semantic Link and Semantic Link Labs.
   • Captures dependencies among model objects to get a comprehensive view of object usage.

2. Query Log Collection:

   • Captures both summary query counts and detailed DAX query logs.

3. Unused Column Identification:

   • Compares lakehouse/warehouse and model metadata to identify unused columns in your model's source lakehouse/warehouse.
   • Removing unused columns will result in greater data compression and performance.

4. Cold Cache & Resident Statistics:

   • Deploys a cloned model to measure cold cache performance.
   • Records detailed resident statistics (e.g., memory load, sizes) for each column.

5. Star Schema Generation:

   • Produces a set of star schema tables, making it easy to integrate with reporting tools.

https%3A%2F%2Fgithub.com%2Fmicrosoft%2Ffabric-toolbox%2Fblob%2Fmain%2Ftools%2FSemanticModelAudit%2Fnotebook%2FSemanticModelAudit.ipynb

[justinmartin]

Added the link!

[Nachtje07]

Yes, me too. Looks really cool stuff I want to try out

[rgadea]

Very interesting! I'd like to get the notebook link. Thanks in advance!