Skip to main content
Microsoft Idea

Power BI

Needs Votes

List where a column or measure is used in a report

Vote (904) Share
Dave Gugg's profile image

Dave Gugg on 17 Dec 2016 06:00:28

It can be unwieldy to manage measures and columns, especially when custom measures and columns are built on top of other measures and columns. It would be helpful to have a [Where Used] option to provide a list of visuals and/or columns/measures where a particular column is used. That way you can delete unneeded measures/columns without worrying about breaking everything.

Comments (55)
Dave Gugg's profile image Profile Picture

Ben Leanna on 21 Dec 2023 12:40:58

RE: List where a column or measure is used in a report

Using the Power BI API for a reports.Get() method, it shows *SOME* information on each report. If they just added in more metadata to the API to show which tables/measures/columns/etc were being used in that report, automation could be done to find specific reports using a particular table. Please add this!

Dave Gugg's profile image Profile Picture

Evan Caffee on 02 Oct 2023 14:49:58

RE: List where a column or measure is used in a report

"Trace Precedents" and "Trace Dependents" have been standard, native Excel tools to determine what cell(s) effect(s) or is/are being effected by the currently selected cell. PBI should have a column/field level functionality of the same variety. This is basic.

Dave Gugg's profile image Profile Picture

Jan Stottko on 07 Sep 2023 10:43:05

RE: List where a column or measure is used in a report

Would be great to have this feature in Power BI.

Dave Gugg's profile image Profile Picture

David Cantero on 21 Jun 2023 06:30:52

RE: List where a column or measure is used in a report

Yep, something really needed

Dave Gugg's profile image Profile Picture

Devender Bolledla on 29 May 2023 00:56:58

RE: List where a column or measure is used in a report

Worth having it. Saves a lot of time.

Dave Gugg's profile image Profile Picture

Anthony Alessi on 28 Apr 2023 17:28:28

RE: List where a column or measure is used in a report

This feature would be a huge help in all versions of desktop (Report Server and Service optimized).


Came here from: Solved: How to find where a column is used? - Microsoft Power BI Community


The solutions are all external tools:


VertiPaq Analyzer
 Power BI Helper
 
but had the most success with:
Power BI Cleaner Gen2 The BIccountant
Dave Gugg's profile image Profile Picture

Marcel ten Broeke on 14 Apr 2023 13:28:24

RE: List where a column or measure is used in a report

How many votes does an idea need ? In the past with Uservoice for Configurationmanager for example, many idea's has been started as investigation with more then half the votes this one has for example.


anyway, this is a very welcome feature to optimize the to be published reports without breaking potential relations in larger models.

Dave Gugg's profile image Profile Picture

Md Jubaer Mahmud on 04 Jan 2023 15:01:55

RE: List where a column or measure is used in a report

A highly needed feature!

Dave Gugg's profile image Profile Picture

Daniel Cassidy on 16 Nov 2022 12:35:46

RE: List where a column or measure is used in a report

I'm surprised PowerBI doesn't have this feature, it seems like a fairly basic requirement. I have voted for it. :-)

Dave Gugg's profile image Profile Picture

John Olav Bonsak on 04 Oct 2022 12:01:39

RE: List where a column or measure is used in a report

Any improvement which contributes to closing this transparency/lineage gap would be very much appreciated, PBI Team!