Forum Discussion
Reduce a dataset
- 6 years ago
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
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.