impossible to import a list of accounts from excel

(2) Share

Report

Posted on by PP-05072329-0

I am trying to import a list of companies and contacts in Dynamics 365 Sales but it does not let me, and tells me that the group does not have privileges. I have managed profile in Office 365, but it lets me do such a simple task. I am putting faith in Dynamics again but I see that it is still as rigid.

All responses (2)

Answers (1)

Suggested answer

Rahul Purush 19 on at

Like (1)

Report
impossible to import a list of accounts from excel

You do need to make sure that your user profile has the appropriate Security privileges required to do the data import. In your instance, you need to have

Create (in addition to Read / Write) privilege on the Account table and Contact table. Please do add Append / Append To privilege as per your requirement.

Privileges on the Data Import and Data Map tables - Kindly grant Global scope for the Data Import and Data Map tables for all privileges except Delete privilege for which assign it with a Scope of Local (User)

Kindly update any one of the Security Role that is assigned to you to include the above mentioned privileges. Alternatively, you can create a new Security Role called Data Importer and then assign the privileges.

If you could do that and give it a try, it should work.

Alternatively, if you have System Administrator role, then you do not need to update Security Roles.
Verified answer

Daivat Vartak (v-9d... 7,805 Super User 2025 Season 1 on at

Like (2)

Report

impossible to import a list of accounts from excel

Hello PP-05072329-0,

You can follow the simple steps to import your data into Dynamics 365 Sales application.

1. Download a template for data import (Data import template for Dynamics 365 Customer Engagement (on-premises) | Microsoft Learn)

2. Import accounts, leads, or other data (Import accounts, leads, and more into Dynamics 365 Customer Engagement (on-premises) | Microsoft Learn)

If you are mapping the owner field while importing the data, please ensure that the user (Owner you selected during import) must have permission to create, read, and write permission to the same tables/entity.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me.

Best Regards,
Daivat Vartak

Community site session details

impossible to import a list of accounts from excel

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

impossible to import a list of accounts from excel

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates