Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Best Tool to Identify and Remove Unused Measures

  • 1.  Best Tool to Identify and Remove Unused Measures

    Bronze Contributor
    Posted Feb 05, 2019 12:17 PM
    What is the best tool to identify unused measures? I've found three tools in my search, but these are not quite hitting the mark:

    Radacad's Power BI Helper:
    http://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper
    Current version 0.1 is free, and will identify unused tables, but not measures.

    Data Vizioner: 
    https://www.datavizioner.com
    Free trial, then $40/month. I tried the trial and found it to be very a slick online interface giving metadata about your report. It recognizes there are unused fields / tables, but I don't see anywhere that these are listed, let alone unused measures.

    Power BI Assistant: https://github.com/didierterrien/Power-BI-assistant
    This looks like an absolutely awesome tool, which is itself a power BI file that queries details of other open PBIX files on your machine.  Unfortunately, I was unable to get it to to function and have submitted an issue on Github to the developer Didier Terrien, who appears to be active, so I hope to be able to report more later.

    Does anybody know of any other tools that are helpful in removing unused measures and columns?

    ------------------------------
    Ryan Perry
    Business Systems Analyst
    Auric Solar
    ------------------------------


  • 2.  RE: Best Tool to Identify and Remove Unused Measures

    Gold Contributor
    Posted Feb 05, 2019 01:02 PM
    Hi Scott!

    Have your tried DAX studio. May be that can help.

    Although there will be a problem between xvelocity and query engine. But, it takes out the unused measures though.

    - sam

    ------------------------------
    Sam Chatterjee
    Power Business Intellgience Developer
    Sambi Data
    Copenhagen
    +45 9163 4228
    ------------------------------



  • 3.  RE: Best Tool to Identify and Remove Unused Measures

    Top Contributor
    Posted Feb 05, 2019 04:49 PM
    Hi Ryan,

    Please have a look at following blog;

    https://exceleratorbi.com.au/measure-dependencies-power-bi/

    It seems like some work but it is achievable.

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Sr. BI Consultant
    Karachi, Pakistan
    ------------------------------



  • 4.  RE: Best Tool to Identify and Remove Unused Measures

    Posted Oct 11, 2019 08:00 AM
    This is the best method I have found so far. Brilliant work from Lars.
    https://ssbi-blog.de/technical-topics-english/how-to-identify-measures-not-used-in-your-pbix-file

    Enjoy!
    Fredrik

    ------------------------------
    Fredrik Vestin
    Consultant
    ÖRNSKÖLDSVIK
    706982556
    ------------------------------



  • 5.  RE: Best Tool to Identify and Remove Unused Measures

    Bronze Contributor
    Posted Oct 11, 2019 11:38 AM
      |   view attached
    Hi Ryan,

    There are some really good suggestions here with looking at tools to get the data. DAX studio is pretty useful for getting a number of pieces quickly.

    One tool that I've used a number of times is the Blue Granite Tabular model Documentor

    It doesn't have exactly the thing your looking for natively, but I extended it to include the calculation dependencies and to visualize them. (attached)

    You will need to get the server name and Model name from DAX Studio and edit the parameters accordingly.

    Once that's done, there is a report page called Dependencies that draws out a graph of the objects. If you pick measures, you'd be able to see which measures/columns they depend on.




    ------------------------------
    Jarid McKenzie
    Lead Analytics Architect
    Iteration Insights
    jarid.mckenzie@iterationinsights.com
    ------------------------------

    Attachment(s)



  • 6.  RE: Best Tool to Identify and Remove Unused Measures

    Bronze Contributor
    Posted Feb 06, 2019 10:19 AM
    @Sam Chatterjee, Thanks for the pointer towards DAX Studio. I've installed and it's a agreat new tool for my box.
    @Hasham Niaz, The link you provided is also instructional.

    Both of these approaches use the same ​​​Server Analysis Services Tabular service to pull data about the model. These, both appear able to find measure dependencies for other measures, but visual dependencies aren't clear.  IE it will flag a measure if used in another measure, but finding dependencies where it is used directly in a visual is less clear.

    I might be able to piece it together, which is probably a good long term self development learning project, though it will likely take a lot longer than just saving a copy of the file, and test-deleting any measures I think likely aren't used to see if any visuals break.  Thank you both for your input. 


    ------------------------------
    Ryan Perry
    Business Systems Analyst
    Auric Solar
    ------------------------------



  • 7.  RE: Best Tool to Identify and Remove Unused Measures

    Gold Contributor
    Posted Feb 06, 2019 04:25 PM
    Thanks Ryan

    I love to work with PowerbI. Meanwhile, if you feel good of my effort, please recommend my solution and give me some points..It will help me to grow and keep me motivated.

    Love to help you buddy in near future.

    - sam

    ------------------------------
    Sam Chatterjee
    Power Business Intellgience Developer
    Sambi Data
    Copenhagen
    +45 9163 4228
    ------------------------------



  • 8.  RE: Best Tool to Identify and Remove Unused Measures

    Bronze Contributor
    Posted Feb 26, 2019 11:55 AM

    Update: Didier Terrien has been very attentive in supporting the Power BI Assistant.
    In order to make it work, the security settings of PBI had to be adjusted, which he has outlined on his page:

    Power BI assistant troubleshooting Archives - The BI Power



    ------------------------------
    Ryan Perry
    Business Systems Analyst
    Auric Solar
    ------------------------------



  • 9.  RE: Best Tool to Identify and Remove Unused Measures

    Gold Contributor
    Posted Feb 26, 2019 12:53 PM
    Thanks Ryan for a great insight.

    ------------------------------
    Sam Chatterjee
    Business Intelligence Developer
    Sam Analytiks
    (M):-(+45) 9163 4228
    URL:- https://www.samanalytiks.com
    ------------------------------