Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
will i be able to display more then 1000000 rows
it throws a error while displaying the report
Solved! Go to Solution.
Hi @Anonymous,
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
Is there a way to show a personalised message when this error shows up on a visual? For example when the error shows up, the message I would like to display should say, 'please select a filter to view the table'.
Thanks.
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 ??
Hi @Anonymous,
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