data size limitation on the power bi report

[Gaja24]

Hi everyone,

I reviewed the community posts regarding data limitations in Power BI reports, but I couldn't find a solution to the issue I'm facing.

We have a report with 40 columns and over 25,000  plus rows. The report includes filters that allow users to type values to filter for specific data. However, for some reason, the filter has stopped working and displays the following error (screenshot below).

Does anyone have insights into what might be causing this limitation and how we can resolve it?

Thanks in advance for your help.

[v-hashadapu · Accepted solution]

Hi @Gaja24 , Thank you for reaching out to the Microsoft Community Forum.

The issue is most likely caused by Power BI’s limitation of displaying only up to 1,000 unique values in slicers and certain filter visuals. With over 25,000 rows and potentially as many unique "ServicerLoanNumber" values, this limit is being exceeded especially if you're using a custom visual for filtering.

@lbendlin suggestion to use the built-in Filter Pane is the best choice, as it handles high-cardinality fields better and supports text-based search without hitting the same rendering limits. Switch to using the Filter Pane instead of a slicer or custom visual for this field. Avoid modifying the “Maximum number of rows to load” setting in Power BI Desktop, as it only affects the query editor preview and not report visuals. If needed, you can also pre-filter the data in Power Query or optimize the model by reducing unnecessary unique values in "ServicerLoanNumber" to improve overall performance.

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[Gaja24]

Thanks v-hashsdapu and Ibendin for your suggestions, text based search resolved this issues.

[lbendlin]

If you only need to search for individual values (or a small number) then consider using the Filter Pane instead of this custom visual.