Searching for Commands used in a Dashboard

[tobi94MTW]

Hi,

is there any way to search (similar as you can search a measure or column under the 'Data' header) for specific commands, i.e. whether they are used at some point in the Dashboard. This would imply to search through the code underlying all Measures that are written in the file.

My desire for this stems from the fact that I have long worked on a Dashboard. Now, I am trying to clean the relationship structure and tables loaded into the dashboard. However, I vaguely remember to have used 'USERELATIONSHIP' at some point. In order to know, which of the inactive relationships I rely upon I would want to search for 'USERELATIONSHIP' and get an indication which measure utilizes it. Then I could quickly see which relations I should not delete. 

The best resource towards this I found is: What makes up a Power BI Desktop PBIX File - FourMoo | Power BI | Data Analytics

But I did not grasp such an option from the explanations there.

Thanks a lot for any feedback 🙂

[v-shex-msft · Accepted solution]

HI @tobi94MTW,

You can take a look at the following links if help with your requirement.

Connect to power bi data model:

Connect to Power BI Desktop Model from Excel and SSMS (biinsight.com)

Performance analyze:

Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...

Measure usages:

How to identify Measures not used in your pbix file | THE SELF-SERVICE-BI BLOG (ssbi-blog.de)

Regards,

Xiaoxin Sheng