cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rodrigo_Carvalh
Advocate II
Advocate II

How to find where a column is used?

I do have a model with many tables and calculated columns. Sometimes I want to find out if a column is used somewhere, if it is not used I can delete it cleaning up the model. I usually delete the column and look for errors, is there a better way to do it?

Thanks!

1 ACCEPTED SOLUTION

If you want to track the dependencies in DAX, you can use VertiPaq Analyzer. It extracts all the DAX expressions for calculated columns, measures and calculated tables. Then you can search in the list... not optimal, there is a DMV provinding dependencies info for calculations, but we didn't incorporate in in a tool to navigate dependencies more easily.

 

However, what is really missing is a feature that check whether a column/measure is used in any report or not. But in case you publish the report on Power BI and then connect from other reports or from Excel... then it will be impossible to track such a dependency in any case.

View solution in original post

6 REPLIES 6

If you want to track the dependencies in DAX, you can use VertiPaq Analyzer. It extracts all the DAX expressions for calculated columns, measures and calculated tables. Then you can search in the list... not optimal, there is a DMV provinding dependencies info for calculations, but we didn't incorporate in in a tool to navigate dependencies more easily.

 

However, what is really missing is a feature that check whether a column/measure is used in any report or not. But in case you publish the report on Power BI and then connect from other reports or from Excel... then it will be impossible to track such a dependency in any case.

View solution in original post

@marcorusso Hi Marco, just wondering if you were aware of any Power BI 'Idea' to support the need for a funcionality to see where a measure or column is used in a report?

 

I have been looking but can't seem to find anything to upvote before opening a new one...!

 

Many thanks, 

 

Matt Alexander

Not aware of that - if you searched and didn't find it, create a new one!

 

Marco Russo - SQLBI

Thanks @marcorusso - just wanted to check to avoid duplicating ideas!

 

Matt

Looks like there is an idea submitted to find where a column or measure is used.

 

Go here to vote for it!

rynelees
Helper I
Helper I

It'd be really nice if you could find this under modeling or something like that but I don't think power bi provides a feature like that.

 

The best way I know of doing that is by going through your pages and clicking on each visual to see if the column is being used. 

 

That being said, sometimes I use a calculated column as a way to manipulate something before I make the calculated column I actually need. So if you make some calculated columns that are based on other calculated columns, like me, I don't think there's a way to find out that dependency without looking at each formula. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!