Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi,
I had the problem a few times and created a simple web site to analyze a PBIX file and find unused fields
this isnt working for SSAS tabular Live Connection to power bi
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,
Happy to help!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |