I attempted several methods to import data into Dynamics 365 Sales Professional but consistently encountered error messages, even when using Dataverse to upload the file to the Account table. The issue arises because the first three columns contain system-generated data and record IDs. While I can update existing records, I am unable to import new ones, as the system prompts that some required fields are missing—specifically those first three system-only fields.
Are you using "Templates for data import" under "Data Management" in "Advanced Settings"? If not, try that. Otherwise, import new data from a CSV. If you are attempting to import using an Excel file downloaded from a view, you won't be successful.
Was this reply helpful?YesNo
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.