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 support?

Thanks

6 Replies

  • dm-p's avatar
    dm-p
    Super User
    2 years ago

    Hi Anonymous,

     

    For looking at the source code, it looks like they are using the maximum limit of 30,000 rows. This means that if you have more than 30,000 unique values of the column you're attempting to filter, then some of them will be omitted based on the order they are sent to the visual by Power BI.

     

    Regards,

     

    Daniel

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks! If that's how it is, is there a way to prompt the end user enter the value for filtering?

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Have a training session with them where you teach them how to use the filter pane.

  • 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?

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      It means that this custom visual is not suitable. The Filter pane will be able to handle the volume.

    • dm-p's avatar
      dm-p
      Super 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.