Reduce a dataset

[Lidou_Cand]

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

[v-jayw-msft]

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.

[amitchandak · Accepted 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...

[lbendlin]

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.