Microsoft Dynamics 365 | Integration, Dataverse...

Publishing changes slow using Data Connector and Excel Ad-in up to an hour

(0) Share

Report

Posted on by Ingrid@InResidence

I use Excel connected to Dynamics 365 to make bulk edits to our product reference data in Dynamics, for example, price changes, or description changes. The Data Connector times out after an hour and during that time only approximately 1000 changes are processed. If my table has more edits than that I reload and try again and the next 1000 changes get processed, and so on. This is extremely tedious and I know it is not normal. We have a sister company that also uses Dynamics 365, with an almost identical set-up, and it only takes me a few minutes to publish 1000's of changes in that system. Our developer has not yet managed to identify the cause of the problem. I would be very grateful for a troubleshooting checklist for potential causes of this slowness.

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

Hi Partner,

Can you tell me what app you are using in D365?

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

I would ask you to check below components for your troubleshooting

1. Check Sync plugins running for the entity which you are updating from excel

2. Check Real time workflow and any custom workflow code

Try to disable custom plugins oneb by one to check what plugin is causing this issue.

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Ingrid@InResidence 10 on at

Like (0)

Report

Hi Leah,

we are using Dynamics 365 Business Central.

Regards,

Ingrid

Was this reply helpful? Yes No
Ingrid@InResidence 10 on at

Like (0)

Report

Dear Bipin,

thank you for your suggestions. I shall pass on that information to our developer.

I have had a quick look myself and from what I can see in the Synchronisation Log all is OK, sync jobs are 40-800ms. We don't intentionally use any automated workflows. I've deleted the few that have been generated in the Query Entries Log. Those queries were taking 1-5s. Deleting them hasn't made any improvement.

Regards,

Ingrid

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Ingrid,

You can post the thread in following forum, where you will get more help:

Dynamics 365 Business Central - Forums, Blogs, Support

Was this reply helpful? Yes No
Ingrid@InResidence 10 on at

Like (0)

Report

Thank you Leah. I have posted in that forum now. The link is community.dynamics.com/.../publishing-item-updates-using-excel-via-data-connector-is-slow-timing-out-after-an-hour.

Was this reply helpful? Yes No