Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |