Skip to main content

Power BI

Needs Votes

Identify unused tables/ columns

Vote (232) Share
LarsSchreiber's profile image

LarsSchreiber on 08 Dec 2015 06:19:23

With growing data models and 10s or 100s of measures its hard to keep the overview wich of the columns are neither used in a measure, nor as a slicer/ filter. For optimizing the data model (e. g. removing unnecessary columns) it would be great to know who they are.

Comments (16)
LarsSchreiber's profile image Profile Picture

Paul Mallison on 05 Jul 2020 22:59:18

RE: Identify unused tables/ columns

This would be a real time-saver.

LarsSchreiber's profile image Profile Picture

Power BI User on 05 Jul 2020 22:48:48

RE: Identify unused tables/ columns

I love this, was about to add a similar idea. This would help the cleanup work immensly.

LarsSchreiber's profile image Profile Picture

Jorge Mena on 05 Jul 2020 22:38:19

RE: Identify unused tables/ columns

This would super useful for cleaning the data model o just to see what measures are necessary and not. Maybe a Highlight tool would be great in the relationship view or in the report view.

LarsSchreiber's profile image Profile Picture

Mat Webb on 05 Jul 2020 22:25:39

RE: Identify unused tables/ columns

This would be a perfect feature to add to the main application or as an ofshoot application that could scan your file and produce a quick report of unused measures/calc columns.

i wonder if its possible for a 3rd party application to do this?

LarsSchreiber's profile image Profile Picture

Jan van Werkhoven on 05 Jul 2020 22:25:02

RE: Identify unused tables/ columns

Great idea! Would love to have a model optimizer that removes unused columns etc. :)

LarsSchreiber's profile image Profile Picture

TJ Doherty on 05 Jul 2020 22:17:34

RE: Identify unused tables/ columns

Would also be great to have a list of where calculated measures/columns are used in the report.

Merged Idea (1)