The query result is too large

posted on January 14th, 2026

Answered

robbie asked on January 14, 2026

We are using nuxt and vue 4.

we have random user queries that are erroring and restarting the flexmonster service due to query being too large according to the logs. How do i configure for this to handle gracefully?

2026-01-14 15:23:12.9708 | ERROR | The query result is too large

at Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.<DiscoverMembers>d__25.MoveNext() in C:\Git\PIVOT\projects\Datasource Proxies\Microsoft SSAS\Flexmonster.Accelerator\Flexmonster.Accelerator.Core\Controllers\FlexmonsterProxyController.cs:line 662

1 answer

Public

Maksym Diachenko ⋅ Flexmonster ⋅ January 16, 2026

Hello, Robbie,

Thank you for contacting us.

This error is caused by a limitation or misconfiguration in SSAS, rather than an issue with the Accelerator itself.
To handle this scenario, we recommend reducing the amount of returned data. This can be done by:

Applying filters in the report before loading the data.
Using the subquery to limit the amount of loaded data by MDX query condition: https://www.flexmonster.com/api/data-source-object/#subquery

Using filters allows switching between different subsets of data which were not initially loaded, while a subquery cuts off part of the data entirely and prevents it from being loaded at all. Both methods reduce the amount of data returned by the query, hence they may help resolve this issue.

Please let us know if our answer was helpful.

Best Regards,
Maksym

The query result is too large

1 answer

Please sign in or register to submit your answer