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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi hummingbird 

I am unable to locate the "Column Usage" feature in DAX Studio as advised by you. 

Could you please elaborate more on where and how should I be able to access it.

Thanks

EarlCarroll's avatar
EarlCarroll
Frequent Visitor
2 years ago

Hi

did you find the column usage feature? I am trying to do the same/

Thanks

  • Brunner_BI's avatar
    Brunner_BI
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    You need to install the tool "Measure Killer" for that.

    hummingbird DAX Studio has no such feature

    Also, Power BI Helper does not work for shared datasets.

    • Meie's avatar
      Meie
      Regular Visitor
      2 years ago

      We are using analyze in Excel pretty much, is it possible to detect the measures which are used in Excel and not in Power BI?

      • Brunner_BI's avatar
        Brunner_BI
        Icon for Impactful Individual rankImpactful Individual
        2 years ago

        Yes, it can do that!