Any way to increase the 5000-item fetch limit in CRM Online?

(0) Share

Report

Posted on by Community Member

There are sources that explain how to increase this limit in an on-premise instance (for example here).

However, I need to know whether a client of the Online version of CRM (now called Dynamics 365) is able to change this limit for their Online instance.

Any knowledge on this would be appreciated.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Nadeeja Bomiriya 6,804 on at

Like (1)

Report

Hi Michel,

To answer the question, I would say, no. You could try to create a support ticket with Microsoft, but it's unlikely that they would. But give it a go anyway. I know Microsoft support can increase other limits such as custom entity limit.

In saying that, it is possible to workaround this limitation. Please check out below articles.

http://www.inogic.com/blog/2015/07/querying-more-than-5000-records-in-dynamics-crm/

https://msdn.microsoft.com/en-us/library/mt269606.aspx

Cheers,

Nadeeja

If the answer solves your problem, please mark as Verified. Thanks.

My Blog: http://dyn365apps.com/ - Follow me on Twitter: https://twitter.com/dyn365apps

LinkedIn: https://www.linkedin.com/in/nadeeja

Was this reply helpful? Yes No
Suggested answer

Alagunellaikumar 6,212 on at

Like (1)

Report

Hi

It is not possible to increase the fetch limit in CRM online. You have to raise ticket to Microsoft

Or you have to adjust your code like below

After you retrieve the account using fetchXML ONSuccess method in javascript

Function OnRetrieveAccountSuccess(records)

{

if (records.__next != null) {

var url = records.__next;

GetAccountRecords(url);

}

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (1)

Report

Hi Michel,

You can raise a ticket to Microsoft and tell them your export limit like 150000 and they will do it for you.

Here's another way:

community.dynamics.com/.../188236

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (1)

Report

What version of CRM Online you are using?

From CRM 2015 update 1 onwards you can export 100,000 records

here:

www.microsoft.com/.../export-to-an-excel-static-worksheet.aspx

www.microsoft.com/.../export-data-to-excel.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Prashant. This is in fact about using FetchXML to get more than 5000 items at a time. But I appreciate the tip anyway.

Was this reply helpful? Yes No