cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akshaypuppal Regular Visitor
Regular Visitor

will i be able to display more then 1000000 rows

will i be able to display more then 1000000 rows

it throws a error while displaying the report

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: will i be able to display more then 1000000 rows

Hi @Akshaypuppal,

 

Power BI creates queries that are as efficient as possible. Under certain situations however, the generated query may not be efficient enough to avoid refresh that would fail. One example of this situation is when a generated query would retrieve an excessively large number of rows (more than 1 million) from the back-end data source, in which case the following error occurs:

 

The resultset of a query to external data source has exceeded
the maximum allowed size of '1000000' rows.

This situation can occur with a simple chart that includes a very high cardinality column, with the aggregation option set to Don’t Summarize. The visual needs to only have columns with a cardinality below 1 million, or must have appropriate filters applied.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team
Community Support Team

Re: will i be able to display more then 1000000 rows

Hi @Akshaypuppal,

 

Power BI creates queries that are as efficient as possible. Under certain situations however, the generated query may not be efficient enough to avoid refresh that would fail. One example of this situation is when a generated query would retrieve an excessively large number of rows (more than 1 million) from the back-end data source, in which case the following error occurs:

 

The resultset of a query to external data source has exceeded
the maximum allowed size of '1000000' rows.

This situation can occur with a simple chart that includes a very high cardinality column, with the aggregation option set to Don’t Summarize. The visual needs to only have columns with a cardinality below 1 million, or must have appropriate filters applied.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: will i be able to display more then 1000000 rows

My question would be why would you want to show 1 million records?

You would not be able to view that much data.
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Akshaypuppal Regular Visitor
Regular Visitor

Re: will i be able to display more then 1000000 rows

I agree i would not be able to see whole data at once anyways  just curious about knowing rather then setting default filters can we do something else ??

Super User
Super User

Re: will i be able to display more then 1000000 rows

You can always view all the data in the Table View in Power BI Desktop
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"