Microsoft Dynamics CRM (Archived)

CRM Online Export more than 10.000 Rows ???

(0) Share

Report

Posted on by Antonio Grazioli

575

I can't export more tahn 10.000 records from my contacts

I 've read that there's a builtin limit, and it's possible to change in CRM on premise...How to do it in CRM Online???

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Royal King 27,686 on at

Like (0)

Report

You can't change it in CRM online. One option to export more than 10000 records is either use reports or POWER BI for online. We recommended using power BI for most of our customers as it automatically refreshes the data without going to crm.

Below post provides all the steps required to connect crm in power BI

www.magnetismsolutions.com/.../power-bi-microsoft-dynamics-crm-2013-part-2

Was this reply helpful? Yes No
Antonio Grazioli 575 on at

Like (0)

Report

Thanks for the info!!!

when i try to connect i get:

"Cannot connect to the specified feed. Verify the connection and try again. Reason: For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method."

Was this reply helpful? Yes No
Antonio Grazioli 575 on at

Like (0)

Report

Sorry, My Fault,

I was trying to access using PowerPivot "oDada Feed"

Reinstaled (It was already shown under add-ins) PowerQuery addin for excel and following your guide it is working. Sadly it is taking forever to download the rows....

So far I got only 1800 rows in more than 10 minutes... ^__^

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

Did you enable content to edit when it showed warning message ?

Was this reply helpful? Yes No
Suggested answer

Remon 1,485 on at

Like (0)

Report

Hi Antonio,

I'm sorry to say the previous answer is not correct.

You can update the value, to do so contact Microsoft Support and tell them what you want.

They will most likely send you a tool to change the value yourself.

Good luck,

Was this reply helpful? Yes No
Suggested answer

Aldo Macedo on at

Like (0)

Report

Hello Antonio,

You could modify the internal register to increase limit for export to Excel.

As Remon told you can contact Microsoft support and they can help you or download a solution to modify it by your own.

Remember to maintain register with 10,000 elements (default) if you are not going to export several ítems in a future.

References:

www.powerobjects.com/.../crm-2011-online-modifymaxexporttool

social.technet.microsoft.com/.../12601.crm-2011-timeouts-and-limits.aspx

msdn.microsoft.com/.../gg328408.aspx

orgdborgsettings.codeplex.com

support.microsoft.com/.../2691237

Best Regards,

Was this reply helpful? Yes No