Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Exporting more than 1 million rows from D365

Posted on by 10

Hi Guys,

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

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,300 Most Valuable Professional on at
    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

  • Salman_Naveed Profile Picture
    Salman_Naveed 10 on at
    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?

  • Verified answer
    Ramit Paul Profile Picture
    Ramit Paul 22,300 Most Valuable Professional on at
    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.

  • Salman_Naveed Profile Picture
    Salman_Naveed 10 on at
    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!

  • Verified answer
    Ramit Paul Profile Picture
    Ramit Paul 22,300 Most Valuable Professional on at
    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans