Forum Discussion

_power_bi's avatar
_power_bi
Icon for Helper I rankHelper I
2 years ago

Large Table Visual that Needs Filtering on RowCount

I have a large table visual where the source is 2M+ rows.  I want to filter the table where only the first 25,000 will appear in the table.  I have a secondary table filter named InDateRange that is ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

There is no need.  Power BI automatically applies a TOPN(501) to your table visual, and then waits for the report user to scroll before calling the next batch.

_power_bi's avatar
_power_bi
Icon for Helper I rankHelper I
2 years ago

There is a need.  This is a large (wide) table.  Without filtering the rows, it will eventually not render the visual. 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    As a report designer you need to push back on this.  There should be no horizontal scrollbar in any of your visuals, and very limited vertical scrolling.

    • _power_bi's avatar
      _power_bi
      Icon for Helper I rankHelper I
      2 years ago

      I agree with you. This is not my choice. Still an issue though.