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 (58)
RE: List where a column or measure is used in a report
This is sorely needed within my org to improve reports built a while ago
RE: List where a column or measure is used in a report
This would be a HUGE win! Please implement whenever possible!
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!
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.
RE: List where a column or measure is used in a report
Would be great to have this feature in Power BI.
RE: List where a column or measure is used in a report
Yep, something really needed
RE: List where a column or measure is used in a report
Worth having it. Saves a lot of time.
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 CommunityThe solutions are all external tools:VertiPaq Analyzer Power BI Helper but had the most success with:Power BI Cleaner Gen2 The BIccountant
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.