Improve Data Pane Search to Support Table and Column Filtering

<p><strong>Note</strong>: this is distinct from the request to <a class="lia-internal-link lia-internal-url lia-internal-url-content-type-idea" href="https://community.fabric.microsoft.com/idea/fbc_ideas/add-search-functionality-to-power-query-queries-pane/4765667" data-lia-auto-title="add search to PowerQuery" data-lia-auto-title-active="0">add search to PowerQuery</a> (also crucial).</p>

<p>The Power BI Desktop Data pane search currently appears to perform a simple text search across table and field names. In large semantic models, this makes it difficult to locate a specific field within a specific table.</p>

<p>For example, if I want to locate the&nbsp;<code>Entered</code> column in the <code>Queue_Official_Daily</code> table, I should be able to search using syntax such as <code>Queue_Official_Daily Entered</code> or <code>Queue_Official_Daily[Entered]</code>.</p>

<p>Currently, searching for the table name causes the entire table and all of its fields to remain visible, while searching for the column name may return the same field from many different tables.&nbsp; Some Suggestions:</p>

<ul>

<li>Qualified <code>Table[Column]</code> search syntax.</li>

<li>Multiple search terms with <code>AND</code> behavior.</li>

<li>Separate Table and Field search/filter boxes.</li>

<li>Fuzzy matching while still respecting table context.</li>

</ul>

<p>Search operators such as <code>table:Queue_Official_Daily</code> AND <code>field:Entered</code>.</p>

<p>This would significantly improve navigation in models containing dozens of tables and hundreds or thousands of fields.</p>

<p>&nbsp;</p>

<p>&nbsp;</p>