Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Optimize PBIX for unused columns

We inherited a large PBIX that contains around 80% unused column. For optimization sake we'd like to remove columns not used in any visualization. Is there an efficient way to search for unused columns, or do we have to click on each visualization, and inventory which columns / measures are being used (e.g. the columns are highlighted in yellow when clicked).


Any ideas?

Regular Visitor


I had the problem a few times and created a simple web site to analyze a PBIX file and find unused fields

Not applicable

this isnt working for SSAS tabular Live Connection to power bi

Super User II
Super User II

Have you been able to approach that?
I hate reading 100 columns to check which one are not used. It's a tedious job.



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Bertrand's excellent utilities does this in Excel.


Presumably he uses dax Studio to extract the data - I'm not sure. Maybe take a look at his code to see if it can be done in Pbix. 

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.