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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Exporting to excel get stuck after 3 lack records and failure

(0) ShareShare
ReportReport
Posted on by 92

Dear Team, 

I am trying export data from dynamics 365,after 3 lack records its getting stuck and showing below error. any help is highly appreciated. Thanks 

26450.png

22464.png

I have the same question (0)
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,869 Super User 2026 Season 1 on at

    Hi,

    How many records do you want to export to excel? Have to tried to apply filter before export to check if the export works fine.

    You can export up to 1 million rows to Excel after PU22:

    docs.microsoft.com/.../export-more-rows

  • JASEEM BBC Profile Picture
    92 on at

    I think its around or more than 1 million ( may be). with filtration its working. but i want to export all data

  • WillWU Profile Picture
    22,363 on at

    Hi JASEEM BBC,

    Please check the event logs? Are you considering using other integration way to access records?

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,869 Super User 2026 Season 1 on at

    Hi JASEEM,

    If the data is too many either you can export in several batch via filter or consider to use reporting solution (e.g. PowerBI) via export from D365FO to your reporting solution database (e.g. export job).

    While you export data to Excel from D365FO UI, you need to click on "Wait" on pop-up message when data is too many so the export job can be continued. There can be limitation of number of records to export so you cannot export all data from an specific form. As already mentioned by Microsoft " By default, the export limit is set to 50,000 rows, but through the Client performance options page, system administrators can adjust the export limit as high as 1 million rows". You can try that.

  • JASEEM BBC Profile Picture
    92 on at

    I have already changed this to 1 million rows.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,869 Super User 2026 Season 1 on at

    Hi JASEEM,

    Ok so just test if it works for your purpose. You can to keep the form up and click on "Wait" once the pop-up message shows.

    If this not work in your case, you can consider the provided suggestions.

  • André Arnaud de Calavon Profile Picture
    305,150 Super User 2026 Season 1 on at

    Hi Jaseem,

    I suppose you tried to export the details from a form grid? If so, have you considered using the Data Management tools and export the data via an Export project?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 804

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 639 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 528

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans