Logo
banner

Blogs

Power BI > How to identify referenced Measures and Columns in Model – II

, July 8, 2022 56 Views

In the earlier blog post, we stated how to identify referenced measures or columns, i.e. whether they are used in other measures or not.
If you haven’t visited the blog post, please click here. It is a very useful blog, especially in the big Power BI models.
But this won’t be helpful when we would want to know whether they are being used in the visuals or not.

Well, the solution is Field Finder. Let’s get into this and check how we can achieve this requirement. 

So, first of all, what is Field Finder and what does it do?
Field Finder is a tool that helps us find which measures and columns are plotted in the visuals and which are not.
First, we would need Field Finder. If you don’t have Field Finder on your machine, you can download it from here. Once you download the Field Finder, we would need to use the (.pbit) file. Let’s see how it works. 

  • Open the Power BI Field Finder.pbit file. 
  • Once it opens, one dialogue box will pop up. In this we need to add the path and name of the report (.pbix) file we need to analyze.
  • Click on the Load button and it’ll get all the information from the selected report. 
  • After loading all the contents you’ll see 4 tabs

    • Instructions. 
    • Columns and Measures. 
    • Page Details. 
    • Helpful Resources

If you want to understand in detail, please visit the site.

Using Field Finder makes our development so easy. We can easily locate the fields if our dataset model is very huge and it becomes tedious when we need to locate the fields manually.  

Thus, this way we can check our complete model to find the unused measures and columns by using DAX Studio and Field Finder.

mm

Inkey

INKEY is your solution partner.
Our focus is to deliver you in-time intelligent innovative solutions ("key") for the problems in hand. Maintaining a quality standard right from the inception of a project is our top most priority.

Our team of talented professionals will execute your projects with dedication and excellence. We take ownership and accountability for the effort that goes into meeting our client’s needs.

Years of experience and proven success of delivering innovative custom solutions.

More posts by

One response to “Power BI > How to identify referenced Measures and Columns in Model – II”

  1. […] After getting all the results, you can easily compare the lists of measures and columns in Excel or in Power BI. Please note this blog will just help you to identify the referenced measure and columns. To check which measures and columns are plotted in the visuals, please refer our next blog here: Referenced measures and columns in visuals […]

Leave a Reply

Your email address will not be published.

The maximum upload file size: 2 MB. You can upload: image, audio, video, document, spreadsheet, interactive, text, archive, code, other. Drop file here