Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Custom Visual Text Filter -- data limitation

HI, I have a very large dataset, imported to my local workspace. When I use the Text Filter to search for data, it doesn't always find it. Is there any limitation of data size that the filter can su...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Daniel,

Thanks for the answer! That's way not enough for me. I have millions of rows.

Is there any way to optimize/make Power BI handle this, or is Power BI simply unable to handle large datasets?

dm-p's avatar
dm-p
Icon for Super User rankSuper User
2 years ago

Power BI Can handle large datasets, but it is designed for aggregation (i.e., minimal data points) when it comes to using visuals on the canvas. Slicers (which are a visual) need to look at all available data, which means that Power BI needs to send all available values to it before its logic can work. This limit is 30K rows (if the visual author has permitted this amount; in this case, they have).

 

As lbendlin has advised, you would need to use the filter pane for such a scenario, as this isn't a visual on the canvas and is not subject to the same limitations.