cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MattKarriker2
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.  

4 REPLIES 4
v-stephen-msft
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.

vstephenmsft_0-1638177094553.png

 

 

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.

 

 

 

lbendlin
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

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

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!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!