Optimize PBIX for unused columns

[sethsanu]

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?

[FabianS]

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]

this isnt working for SSAS tabular Live Connection to power bi

[ibarrau]

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,

[MattAllington]

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.