cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sethsanu
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?

4 REPLIES 4
FabianS
Regular Visitor

Hi,

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/

Anonymous
Not applicable

this isnt working for SSAS tabular Live Connection to power bi

ibarrau
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.

 

Regards,


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. http://www.sqlbi.com/tools/power-pivot-utilities/

 

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

Announcements
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!

secondImage

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.