I need a Table Visual that shows more than 10 million rows

[deepanwita25]

I need a table visual that will show more tha 10 million rows in 1 Visual. The regular power bi visual is exploding..I need a solution for this. I cannot aggregate the value..

[parry2k]

@deepanwita25 imo, this request is insane, what is the point of showing 10 million rows in a table? What is the use case? It doesn't make any sense.

[danextian]

This is more of a resource issue than the visual itself. You might have to spend on a premium or a higher tier fabric capacity.  The resource issue aside, would the users have the time to scroll through more than 10 million rows? 

[deepanwita25]

but is there any visual in Appsource that can help with displaying more than 10 million rows?

[pborah]

Wouldn't this be a memory issue rather than a Power BI issue?

[deepanwita25]

I already have the table imported in Power bi from my database. Its when I select all the combination where there will be more than 10 million data the visual explodes with the following message:

This is how my visualization currently looks:

[danextian]

The error indicates a resource limitation rather than an issue with the visual itself. Displaying over 10 million rows at once is highly demanding, regardless of whether a custom visual is used. Additionally, would you or your users realistically scroll through that many rows? As mentioned in the second sentence of the error message, reduce the data volume by applying filters—either through slicers or by using the TopN filter in the visual pane.

The screenshot below demonstrates filtering the table to the top 100 dates based on the date column.

[deepanwita25]

Sure Thank you for your solution. I already have filters coming from the slicer..this is an organizational solution that I am building..If in case a user selects everything in all the filters available then the visual explodes and gives me an error message..Hence, I asked in the forum, if there is a possibility by any means to get more than 10 million rows in a visual.

[danextian · Accepted solution]

Possibility? Yes. But this is a very demanding ask that requires a much higher capacity. And I wouldn't use a premium or fabric capacity just for that.

Forwarned your users about trying to show all rows. I do that for a few of my reports.