Limitation on add related fields in Analysis Mode

(4) Share

Report

Posted on by MN-03061245-0

Hello everyone!

I was trying to add the "Lot No." from Item Ledger Entries in the Value Entries analysis mode. However, when I insert the column an error occurs.

Follow the steps I made:

I've already filtered to ensure that won't exceed the row limit.

Anyone can help me?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Teagen Boll 3,187 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

There seems to be a limit of 100,000 records for the current analysis views: Analyse list page and query data using data analysis - Business Central | Microsoft Learn

Im not sure if thats changed with recent updates but you may be hitting a record limit in which case you need to add filters to get under that record limit.

Best,

Teagen Boll

Work: Catapult ERP

Social: LinkedIn

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I did a quick test, and it works fine.
Could you add some filters to reduce the number of entries? And then try again?

Was this reply helpful? Yes No
Verified answer

OussamaSabbouh 17,586 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

This looks like an Analysis Mode related-fields limitation/performance issue, not something wrong in your steps. The feature does allow adding fields from related tables, but in this case Value Entry → Item Ledger Entry can be heavy because BC must join the Value Entry rows to Item Ledger Entries and then load the related Lot No.; even with a visible filter, the analysis engine may still interrupt the load if the joined dataset is too expensive. I would try filtering harder before adding the column, for example by Item No. + Posting Date + Document No., or start from Item Ledger Entries instead and add Value Entry-related amounts only if needed. For a stable report, I would not rely on Analysis Mode here; better use a query/report/API page or Power BI dataset joining Value Entry with Item Ledger Entry on Item Ledger Entry No. = Entry No..

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No