Finance | Project Operations, Human Resources, ...

Exporting to excel get stuck after 3 lack records and failure

(0) Share

Report

Posted on by JASEEM BBC

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,686 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
JASEEM BBC 92 on at

Like (0)

Report

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

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report

Hi JASEEM BBC,

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

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,686 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
JASEEM BBC 92 on at

Like (0)

Report

I have already changed this to 1 million rows.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,686 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No