delete unused measures in cube without breaking pbix?

[Anonymous]

I have 3 .pbix  files that consume live from a SSAS cube.

The .bim cube has thousands of measures (most of them not used at all).

My goal is to delete the unused measures in the .bim (without breaking any visual in the .pbix).

Is there a way of opening the 3 .pbix and extracting all the measures/columns used? (or a way of seeing in the .bim which measures are unused?

Ps: each .pbix has 15 pages, so its hard to do it manually.

[Duia]

Hi  @Anonymous ,

You can try to create a list of this measures in DAX Studio to have a list of them, and use for retrieval.

This is the link to download and use Dax Studio:

https://exceleratorbi.com.au/getting-started-dax-studio/

There are related content and tools in the following link, I hope to help you：

Best Tool to Identify and Remove Unused Measures | Power BI Exchange (pbiusergroup.com)

https://community.powerbi.com/t5/Desktop/Identify-Un-used-Measures-delete-bulk/td-p/2118751

https://community.powerbi.com/t5/Desktop/How-to-find-where-a-column-is-used/td-p/227623

Best Regards,

Liu Yang

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

[selimovd · Accepted solution]

Hey @Anonymous ,

the bim is only the data model, you don't see usage there.

I personally would use the Power BI Cleaner from @ImkeF :

https://www.thebiccountant.com/2021/08/23/power-bi-cleaner-gen2-now-covers-analysis-services-models-as-well/

Open the 3 reports with the Power BI Cleaner and then you will see which measures are not used at all.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic