Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@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-workspac...
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-works...
Hi @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.
@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-workspac...
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-works...
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.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |