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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Analysis Mode - Export to Excel Row Limitation

(1) ShareShare
ReportReport
Posted on by 2
I am trying to export the Item list that has nearly 3000 records to Excel after changing the view to Analysis Mode. I have added the vendor name field to the analysis mode using add columns from button (Vendor Number of Item => Name of Vendor). I tried 2 options to export to excel. 
 
1. Right click on the middle of the analysis mode result and clicked Export > Open in Excel button. I could export only 200 rows.
2. Click Analysis Mode button at the top left. And clicked the Open In Excel from the drop-down. I could export only 100 rows.
 
Is there a way to export al items at once when we are in analysis mode with some related table fields added. Thank you.
 
 
I have the same question (0)
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    2,056 on at
    Analysis Mode - Export to Excel Row Limitation
    Hi,
     
    In Analysis Mode, Excel export is limited (100–200 rows). This is by design for performance reasons.
     
    Workaround: use Edit in Excel or Open in Excel from the normal list page (not Analysis Mode) with a saved view including your added columns. That will export all rows. There’s no setting to remove the row limit in Analysis Mode.
     
    Thanks
    Rishabh
  • Suggested answer
    Pallavi Phade Profile Picture
    1,423 on at
    Analysis Mode - Export to Excel Row Limitation
     
    I have used itemledger entries - Analysis mode ,
     
    1) Did expand all 
     
    I did export to Excel for all said rows
     
     
    In excel ,i could export with Group and all records appeared 
     
    Limitation of Export is mentioned in below link
     
    Can you please do it and let me know if it helped . Please mark as "Verified"
     
    Regards
    Pallavi Phade
     
     
     
  • Gerardo Rentería García Profile Picture
    23,446 Most Valuable Professional on at
    Analysis Mode - Export to Excel Row Limitation

    Hi, good day
    I hope this can help you, and give you some hints.

    Export to Excel Limit

    Operation Limits in Dynamics 365 Business Central - Business Central | Microsoft Learn

    Best Regards
    Gerardo

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 3,152

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,944

#3
Sohail Ahmed Profile Picture

Sohail Ahmed 2,444 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans