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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Excel export is very s...
Microsoft Dynamics AX (Archived)

Excel export is very slow and freezes

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All,

I have a custom Form which has many tables as datasources and shows the data of all its tables fields and methods in one grid.

I want the data to be in excel. so I click export to excel button. the data is very Huge, 20000+  records.

its taking huge to export and some times its stuck.

Please suggest how to export the data faster to excel.

Thank you,

Praveen Kumar

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Excel export is very slow and freezes

    This has been mentioned a few times in the last few days but depending on the level and complexity of the export and the level which you wish to manipulate the data you should consider an excel add-in for this kind of work.

    They link directly into the tables in AX and extract information into the format you require and a lot more adaptable and flexible than standard AX reports -  especially for things like vendor transaction analysis. Both come directly into excel and can be manipulated in the same way as a standard excel worksheet. Atlas seems a lot more adept at dealing with complex reports than the Dynamics Excel Add In, however. 

    http://www.globesoftware.com/

  • Martin Dráb Profile Picture
    Martin Dráb 236,503 Most Valuable Professional on at
    RE: Excel export is very slow and freezes

    I wouldn't use direct export from a form for a huge amount of data. Consider using Data Import Export Framework, it supports Excel and it should be many times more efficient.

  • Community Member Profile Picture
    Community Member on at
    RE: Excel export is very slow and freezes

    Thank you for your reply Martin and Bruce,

    In my case I have a custom form which has 2 tables(inventSum,InventDim)  as datasources and they are joined with other tables through query classes to filter the data based on user selection.

    I'm not very sure how I can utilize DIXF in my situation and I do not have any expertise in using that tool. Kindly suggest.

    Thanks,

    Praveen

  • Martin Dráb Profile Picture
    Martin Dráb 236,503 Most Valuable Professional on at
    RE: Excel export is very slow and freezes

    Your options depend on how complex the thing is. Can you build what you need as an AOT query? Then you could use it in Excel add-in, or maybe even for a DIXF entity. Maybe the whole idea to take the data from the current form is wrong and you should first design the query. (You might use it for the form too, at the end.)

    It also depends on how important the requirement is. If it's something that's used often and must be very fast, it's worth more effort than if it's something that nobody actually needs and the user was just lazy to add a filter.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans