46
Dynamics 365 allows user to export records up to 100,000 rows to Excel.
However, in order to export more than 100,000 rows of records, it is necessary to split the export into multiple parts.
And that is too troublesome because splitting data need advanced search function and so on.
It would be more convenient if eliminating the upper limit of exporting records or changing it to a larger value (e.g. 10,000,000).
Category: General
STATUS DETAILS
Needs Votes

Comments

M

For example, I am configuring pivot excel analyses report for the customer that has more than 3000 new lead records on daily basis. I have created the report/analyses and uploaded as template so that the users can download it any time and see the analyses. They need to have the same analyses on the monthly or quarterly level but the record number exceeds the maximum of number of columns for 100K rows is 5 columns i.e. 500000 cells. 

The report combines data from 2 tables, so I am not able to use data platform import option. Even if I could, it would not be user friendly option for the end users. If I use data flows to fill the excel I would still hit the maximum record defined by Excel .

I hope this use case will help you to think of a better solution when it comes to excel data export .

Category: General

M

With reference to the last comment, I don't see an Org Setting MaxRecordsForExportToExcel. Am I missing something?

Category: General

M

We need to add a new field on the contact entity - that was an afterthought. So we add the new field and then want to add different values to 50k of our 400k+ contacts. That requires doing multiple export sheets, combining them together, doing a vlookup to put the new field value into the combined export sheet, and finally reimport. If any records have been updated after the export they will fail. This is a brutal process.

Category: General

M

We need to add a new field to the contact record. We then need to update all 400k contacts depending on a unique identifier in their record. We have to export, merge the excel sheets, do a vlookup and insert the value we want, and then import. If any records are edited since they are imported it fails. This is brutal. There is no way to upsert data.

Category: General

M

We are currently exploring options with your request. Can you give us some use cases of why you are editing more than 100,000 rows in Excel, and what you are doing with this data? This would help us build a better solution that can meet your needs. Thanks the Core Sales PM Team.

Category: General

M

You can already do this by changing the Organization Settings Editor managed solution.  You can get it here https://github.com/seanmcne/OrgDbOrgSettings.  Change the MaxRecordsForExportToExcel to as high as 1,000,000.

Category: General