Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Searching and filtering Large dimensions

Good day forum
I am looking for ideas to help spead along search and filter options for a large dimension table.  We ahve the need to for our customer service team to look up customer transactions and reprint receipt details.  Our customer dimension contains roughly 50M rows.  Using the defailt slicer with the serach feature turned on is very slow as the slicer has to load before the search feature is availalble. 

I have reviewed the Text Filter visual available from AppSource but this visual will not show how many customer records fit the criteria nor show the filtered list.  

Does anyone have any other suggestions or solutions that have worked for you when dealing with large dimeninions and very granular data?


Thanks in advance for your support.  

Community Support
Community Support

Hi @MattKarriker2 ,


How about Smart Filter by OKViz?

Smart Filter by OKViz


Or you can create a hierarchy to reduce the difficulty of filtering. For example, you can build a hierarchy based on gender and initials.




Best Regards,

Stephen Tao


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.




Super User
Super User

Assuming you are using Import mode for that dimension this will pretty much be your best performance. What capacity SKU are you running this on? How much memory does it have?

@lbendlin This dimension is set to dual as part of a composite model against Synapse.  Our datasets are running in P3 capacity, 100GB and our report files are running on a P2 capacity,50BG.   

As @v-stephen-msft suggested you may need to find ways to get the cardinality levels down somehow before you search.  If you can't do that then you may need to look for other tools besides Power BI.

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!