Result set of a query to external data source exceeded the maximum allowed size of 100000 rows

[Anonymous]

Is there a recommanded solution to manage more than 1 Million rows in Direct Query mode?

Requiremnt:

The table in the report should show only 999999 rows of data, at the same time the table should alllow users to sort the data based on any column.

[Hariharan_R · Accepted solution]

Hi,

Add slicers and filters to limit the data on the visual.

Thanks

Hari

[amitchandak]

@Anonymous , when your query is run against database max result it can bring to power bi i 1 M rows , if it is more than that you will face this issue. Limit your visual for a number of rows, do not use line level field. Avoid bi-directional join

Also, check the measures for a few row-level context calculations.

Or share the measure in the visual

[Anonymous]

@amitchandak I have only one table visual on the report page which is working as a drill through the page. The table is using 5 direct columns from the Azure Analysis Cube and 2 aggregation measures(again from cube).