Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
meddojeddo
Helper IV
Helper IV

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

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?

1 REPLY 1
DavisBI
Solution Specialist
Solution Specialist

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!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.