Hi guys,
While Initial Sync Dual-Write from F&O to Dataverse, I got this message :
Warning:[DWCE0001] Export was skipped. Max lookup count supported in Initial Sync stage is 10. Current lookup count 11. .....
I noticed the warning also include an advice to look for Microsoft Docs -> To fix the issue refer to https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/retrieve-related-entities-query
But sadly, I don't know what is the meaning of all that. Not sure what to do after that.
Would you mind to explain a bit what is that all about and how to resolve it ?
Hi Tony,
This issue seems to be related to a limitation of Dataverse, suggest you to go to the Power Apps forum for more help:
powerusers.microsoft.com/.../PowerApps1
There is a workaround:
Split the initial sync in to 3 steps.
In the first step, remove some of the lookup fields from the dual-write entity map that are not mandatory and bring the number of lookups to 10. Once the lookup fields are removed, save the map and do the initial sync. Once the initial sync for the first step is successful, add the remaining lookup fields and remove the lookup fields that got initial synced in first step. Once again make sure the number of lookup fields is 10. Save the map and run the initial sync. Repeat these steps to make sure all the lookup fields are initial synced. Now add all the lookup fields back to the map, save the map and run the map with skip initial sync. This will enable the map for live sync mode.
Hi Tracy,
This is sound like a great idea. I would like to do that. But first may I know, in the last step you're mentioned, how to change Master to initial Sync to Finance and Operation, because normally it is defaulted to Dataverse, and I should click Initial sync in order to change it to FinOps.
Thanks
The last step means just skip initial sync and make the dual write entity is running, as we have done initial sync in previous steps. Master to initial Sync is just a setting for initial sync.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 783
André Arnaud de Cal... 715 Super User 2025 Season 2
Sohaib Cheema 519 User Group Leader
