Skip to main content

    Power BI

    Needs Votes

    Identify unused tables/ columns

    Vote (148) 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 (10)
    LarsSchreiber's profile image Profile Picture

    b6d3c1d2 d07e-4f79-9d6c-04f091f33ca2 on 05 Jul 2020 23:42:33

    RE: Identify unused tables/ columns

    This is a must-have for people inheriting a field heavy dashboard written by someone else.

    LarsSchreiber's profile image Profile Picture

    f5bbab51 5a93-400a-ab58-194cec396c22 on 05 Jul 2020 23:37:39

    RE: Identify unused tables/ columns

    This is a must have

    LarsSchreiber's profile image Profile Picture

    012292e2 2cf6-4e5d-a627-1f35f635f976 on 05 Jul 2020 23:24:58

    RE: Identify unused tables/ columns

    This would be a great way of informing what code can be removed from SQL queries on established reports without having to go through every single visual.

    LarsSchreiber's profile image Profile Picture

    b69b81e4 44dc-4b57-9c0f-d7fafe199cee on 05 Jul 2020 23:14:26

    RE: Identify unused tables/ columns

    This would be very effective in improving performance

    LarsSchreiber's profile image Profile Picture

    78d46203 056e-4c58-8a6e-a73db51f75b8 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

    67eaba52 3a20-440c-91ef-7cf03de03b95 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

    055d40d8 ce8e-4445-b18d-220e7a79fca2 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

    def4074c ab0e-4664-a92c-5c6132ef917c 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

    b1952711 5819-e611-80e2-c4346bad91c4 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

    cbbe410d 30eb-419e-b76b-98853d4f75d7 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.