Report Rendering Issue

(1) Share

Report

Posted on by Nimsara Jayathilaka.

4,849

Hi Community,

I am facing an issue when running a custom report in Microsoft Dynamics 365 Business Central. When I try to execute the report, it immediately throws an error message and stops without actually running or rendering the report output.

The error message displayed is:

“The operation has been canceled because the number of processed rows exceeded the maximum allowed number of rows (500000). Refine your filters to include less data and try again.”

The main concern is that this error occurs before the report execution starts. It appears that Business Central is iterating or processing a large number of rows internally, even before the report logic or output is generated. Because of this, the report fails instantly.

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

Dynamics 365 Business Central migration

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Dhiren Nagar 1,181 on at

Like (1)

Report
Copy link

Link copied!

Hi,

This may happen when you have used too many data items with large number of records without applying filters or setting up DataItemlink between these data items.

To help you troubleshoot, try following.

1- Limit the number of data items you are using.

2- Apply some default filters or apply DataItemlink between dataitems.

3 - Apply Data/period data item filter manually first to identify which data items is causing this.

These are general guideline but more accurate analysis needs to be done by you.

Regards,

Dhiren.

Was this reply helpful? Yes No