Forum Discussion
Semantic Model Report Usage in Service
How much money do you want to spend on this? You would have to use Azure Log Analytics against the workspace and track all the queries for some time.
"Not being used" is a slippery slope. Could also mean "not being used yet" ...
Hi DPCCGF , I will suggest two approaches
1. If you can get a Paid Measure Killer license, then it will be easy to list out the columns, tables or measures not used by any of the report in the data model. If you want to see how measure killer works you can download the free version and test the features on your local model.
2. Once you enable large semantic model storage setting on your data model. You can use this DMV query ($SYSTEM.DISCOVER_STORAGE_TABLE_COLUMNS) to list out the temperatures of each column in your model. Higher temperature means the column is been queried frequently. You can look out for columns with blank or 0 temperature values and observe the trend for few days and take a call on which columns / tables you want to remove from the model.
Thanks,
Jai 🙂
Hi DPCCGF , I will suggest two approaches
1. If you can get a Paid Measure Killer license, then it will be easy to list out the columns, tables or measures not used by any of the report in the data model. If you want to see how measure killer works you can download the free version and test the features on your local model.
2. Once you enable large semantic model storage setting on your data model. You can use this DMV query ($SYSTEM.DISCOVER_STORAGE_TABLE_COLUMNS) to list out the temperatures of each column in your model. Higher temperature means the column is been queried frequently. You can look out for columns with blank or 0 temperature values and observe the trend for few days and take a call on which columns / tables you want to remove from the model.
Thanks,
Jai 🙂