Reply
Highlighted
Regular Visitor
Posts: 16
Registered: ‎07-11-2018
Accepted Solution

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


Accepted Solutions
Community Support Team
Posts: 1,648
Registered: ‎07-10-2018

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.

View solution in original post


All Replies
Community Support Team
Posts: 1,648
Registered: ‎07-10-2018

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
Posts: 2,794
Registered: ‎06-24-2015

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!"
Regular Visitor
Posts: 16
Registered: ‎07-11-2018

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
Posts: 2,794
Registered: ‎06-24-2015

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!"