Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |