web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Report Rendering Issue
Small and medium business | Business Central, N...
Suggested Answer

Report Rendering Issue

(7) ShareShare
ReportReport
Posted on by Nimsara Jayathilaka. 5,128 Super User 2026 Season 1

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)
  • Suggested answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 2,890 Super User 2026 Season 1 on at
    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.
  • Suggested answer
    Aman Kakkar Profile Picture
    Aman Kakkar 3,532 Super User 2026 Season 1 on at
    Hey,
     
    You can use MaximumDatasetSize property in your Report which sets the maximum amount of rows to be included on the report.
     
    This property will override the hard limit that is set by the Default Max Rows (500000) for Report which setting for Business Central Server instance.
     
    Hope the below mentioned helps -
     
     
    Thanks,
    Aman K
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 101,995 Super User 2026 Season 1 on at
    Hi, hope the following can give you some hints.
    Dynamics 365 Business Central: Report Limits management page
     
    Thanks.
    ZHU
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 17,577 Super User 2026 Season 1 on at
    Hello,
     
    This error is caused by Business Central SaaS platform limits, not by the report layout itself: the system stops execution as soon as the report’s dataset logic (data items, triggers, loops) processes more than 500,000 rows, which can happen before any output is rendered. The usual causes are unfiltered large tables, nested FindSet/Next loops inside report triggers (especially OnAfterGetRecord), missing mandatory date filters, or inefficient key usage. The fix is to filter early and hard (DataItemTableView + mandatory request filters like Posting Date), avoid extra record loops inside triggers, use proper keys, and redesign reports to aggregate or split data if full history is required—otherwise the platform will cancel the run by design.
     
    Regards,
    Oussama Sabbouh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,344 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,742 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans