Is it possible to have the Fields search bar accessible to report viewers on the server?

[meddojeddo]

I want the users to be able to search the whol dataset like in the search bar which is above the fields when you are in build mode on Desktop. Is this possible? If so, how can it be done?

[DavisBI]

Hi, @meddojeddo ,

In your PBID, create a blank query, go to Advance Editor, input the below M code:

let
    Source = AnalysisServices.Database(<Your Tabular Instance Name>, <Your Tabular DB Name>, [Query="SELECT [ID], [COlumnID], [Name], [OrderByColumn] from $SYSTEM.TMSCHEMA_COLUMN_STORAGES where Locale <> 0"])
in
    Source

Note: Tabular Instance Name can be found by DAX Studio.

You'll get a table that contains all the fields in your PowerBI Model, then you can use [Name] as a filter

Mark this post as solution if this helps, thanks!