Forum Discussion
Reduce a dataset
Hello All
I hope you are doing well.
I'm trying to reduce a large dataset.
Is there a way to know all columns and measures which are not used in my reports ?
Thank tou for your help
Lidou_Cand , refer if these can help
https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper
https://radacad.com/usage-metrics-or-do-it-yourself-power-bi-monitoring-report
https://powerbi.microsoft.com/en-us/blog/announcing-improved-report-usage-metrics-in-modern-workspaces/
https://docs.microsoft.com/en-us/power-bi/service-usage-metrics
https://community.powerbi.com/t5/Community-Blog/Power-BI-How-to-view-Usage-metrics-in-Power-BI-workspace/ba-p/762580
3 Replies
I heard there is work planned (either in external tools or directly in Power BI) to identify unused resources. Keep in mind that unused measures do not "cost" anything. Focus just on unused columns.
In DAX Studio you can see the memory impact of each column in your queries (via Advanced...View Metrics). If you are adventurous you can also look into some of the DMVs for more meta data.
Lidou_Cand , refer if these can help
https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper
https://radacad.com/usage-metrics-or-do-it-yourself-power-bi-monitoring-report
https://powerbi.microsoft.com/en-us/blog/announcing-improved-report-usage-metrics-in-modern-workspaces/
https://docs.microsoft.com/en-us/power-bi/service-usage-metrics
https://community.powerbi.com/t5/Community-Blog/Power-BI-How-to-view-Usage-metrics-in-Power-BI-workspace/ba-p/762580Hi Lidou_Cand ,
Check this video.
https://www.youtube.com/watch?v=c-ZqToc85Yc
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
