Exporting more than 1 million rows from D365

(1) Share

Report

Posted on by Salman_Naveed

Hi Guys,

Is there any solution by Microsoft to enable more than one million rows export in csv file format.

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

Ramit Paul 22,795 Most Valuable Professional on at

Like (0)

Report

RE: Exporting more than 1 million rows from D365

Hi Salman,

As per product team's white paper docs.microsoft.com/.../export-more-rows

1 Million is the limit

Was this reply helpful? Yes No
Salman_Naveed 10 on at

Like (0)

Report

RE: Exporting more than 1 million rows from D365

Hi Ramit,

Thanks for your feedback. But i am talking about fetching more than 1 million rows. Can we do that by entering 2.5 Million in maximum row field? Or is there any other solution to this?

Was this reply helpful? Yes No
Verified answer

Ramit Paul 22,795 Most Valuable Professional on at

Like (1)

Report

RE: Exporting more than 1 million rows from D365

HI,

Please check this blog community.dynamics.com/.../export-up-to-1-million-excel-rows-in-one-go

Note- system has limitaion to export upto 1 million row, which means, you need to export multiple times to cater this requirement if more than 1 million rows are required to be exported.

Was this reply helpful? Yes No
Salman_Naveed 10 on at

Like (0)

Report

RE: Exporting more than 1 million rows from D365

Yes I am using D365 F&O. how it can be done? Can you please suggest a mechanism!

Was this reply helpful? Yes No
Verified answer

Ramit Paul 22,795 Most Valuable Professional on at

Like (1)

Report

RE: Exporting more than 1 million rows from D365

Hi,

Is this D365 F&O product you are asking for?

if yes, this is possible, however expport will happen only with excel format.

Was this reply helpful? Yes No