Dynamics Community Forum Thread Details

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (1)

Report

Hi Marcos,

This is a limitation set by Microsoft. There is no setting. It was recently expanded from 2000 to 10000. If you use 'Open in Excel' (if available) instead of 'Export to excel', there is a limitation on 100000 records, so this would possibly be your solution. I don't know which form you have opened, but try to see if 'Open in Excel' is available on this form.

Was this reply helpful? Yes No
Marcos Goncalves on at

Like (0)

Report

Hello André,

Thanks for return.

But there isn't option 'Open in Excel' unfortunately.

Do you know how i can export? This report is so important to me do somes taxes apurations.

My best regards.

Marcos

Was this reply helpful? Yes No
Marcos Goncalves on at

Like (0)

Report

Hello Sukrut

Could you share this code with me?

My best Regards

Marcos

Was this reply helpful? Yes No
Suggested answer

Roberto10 162 on at

Like (0)

Report

Hi Marcos.

You can export this report in 2 iterations. Create a filter on a field (for example date field) to a certain point of this report and export those lines. Then create a new filter from that point on and export again. Then combine those files together. This is what we do when we have to export more than 10K lines.

Roberto

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Marcos,

If you can find a data entity in the target entities for Data Management, you can also use the Data export feature to export your 'report' to e.g. Excel. This is not the limitation in number of rows.

Two iterations like Roberto suggested is also an option, but not when the table will grow rapidly...

Was this reply helpful? Yes No
Marcos Goncalves on at

Like (0)

Report

Hello André

Thanks for the help =)

kind regards

Marcos

Was this reply helpful? Yes No

No record found.