Forum Discussion
Identifying unused columns from a semantic model
Hello! I need help with this requeriment
In the Power BI service, many published semantic models are used across multiple reports. For example, a single semantic model might be the foundation for 20 different reports. Is there a way to determine, for a given semantic model, which columns are (or are not) being used in all the dependent reports? The goal is to identify unused fields in the model so they can be removed to reduce the dataset size. I'm wondering if there's a general method to achieve this without having to review each report individually??
thanks in advance
The external tool "Measure Killer" can run this kind of analysis.
Across all connected Power BI reports, Paginated reports and even Analyze in Excel files it can tell you which columns and measures are used or unused.
5 Replies
- bhanu_gautam
Super User
Lullabit13 Power BI Service Usage Metrics: Power BI Service provides usage metrics reports that can give you insights into which reports and datasets are being used. However, these reports do not provide detailed information about which specific columns are being used.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics
v-priyankataCommunity Support
Hi Lullabit13
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-priyankata
Hi Lullabit13
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-priyankata
Hi Lullabit13
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you. - Brunner_BI
Impactful Individual
The external tool "Measure Killer" can run this kind of analysis.
Across all connected Power BI reports, Paginated reports and even Analyze in Excel files it can tell you which columns and measures are used or unused.
