This tool is designed to provide a comprehensive audit of your Fabric semantic models.
Key Features
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.
Query Log Collection:
- Captures both summary query counts and detailed DAX query logs.
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.
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.
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
