Forum Discussion

maheenshahid199's avatar
maheenshahid199
Regular Visitor
3 years ago
Solved

Identify and delete unused columns from all reports using shared dataset

Hello Everyone,  My boss wants to identify and delete unused columns from all the reports which are using shared datasets(which means one dataset is using in multiple reports). Is there any way ...
Need Help
  • Brunner_BI's avatar
    Brunner_BI
    2 years ago

    As far as I know, Measure Killer is the only tool that can do this currently.

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
3 years ago

Hello maheenshahid199,

 

Yes, there are a few ways to identify unused columns in shared datasets in Power BI. Here are some options:


1. VertiPaq Analyzer - https://www.sqlbi.com/tools/vertipaq-analyzer/

2. Power BI Helper - https://powerbihelper.org/
3. Power BI Cleaner Gen2 The BIccountant - https://www.thebiccountant.com/2021/06/27/power-bi-cleaner-gen2-is-here/

 

Be sure to test your changes thoroughly to make sure that they do not break any existing reports or calculations.