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 so important, I spend so much time trying to optimize models, and to do this, locating fields not being used is so very important, I would say this is my top 1 feature request.
RE: List where a column or measure is used in a report
I would extend this even further and request the ability to have a full dependency report or a performance analyser that would highlight unused columns, calculated columns, measures in visuals, dax, slicers, relations, filters, ...
RE: List where a column or measure is used in a report
Please add this functionality. This is, as others have already mentioned, very necessary to eliminate old unused columns.
RE: List where a column or measure is used in a report
Yes please, this is a must. I sometimes make formulas and columns and later change something and then the old columns are no longer used. It clutters and slows down the Power BI. It would be amazing if we could easily see what columns/measurements are being used in visuals and other columns etc. Please add this!
RE: List where a column or measure is used in a report
This is a an absolute must. As I develop my reports overtime, I have multiple similar measures and many that are no longer necessary and are not used. But there is no way to know which ones they are. This is especially true if multiple developers are involved. I could probably delete 75% of measures and make the reports more accurate, easier to develop and faster to run. Same applied to calculated columns
RE: List where a column or measure is used in a report
Please do this, please. Those of us who are diligent documenters will really appreciate the ability to speed this up. Thank you.
RE: List where a column or measure is used in a report
Right now I'm manually documenting every field, measure, calculated column and how they're used for regulatory purposes. PBI needs a tool to allow easily allow this documentation and also to allow us to clean up unused data.
RE: List where a column or measure is used in a report
Ability to trace/highlight columns and measures leveraged in a report is an essential missing component our of Power BI. Need to easily identify what columns, measures, and columns leveraged within measures & custom columns are used across a report / .PBIX.
Complimented with the ability to switch to view the opposite of columns and measures not leveraged in the report, then option to bulk hide, retain, or remove these ancillary columns and measures will allow data models to be optimized and increase performance.
RE: List where a column or measure is used in a report
Hi All,
I had the problem a few times and created a simple web site to analyze a PBIX file and find unused fields
https://analyzepbix.azureedge.net/
RE: List where a column or measure is used in a report
'+1 please.