Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Error when importing data into entity

(0) ShareShare
ReportReport
Posted on by

Hi there! I'm constantly getting an error when importing data from Excel into entity:powerapps_01.png

Categories:
  • Community Power Platform Member Profile Picture
    on at
    Re: Error when importing data into entity

    I deleted the whole environment to start from scratch, and now it's working fine. Thanks for your replies!

  • Verified answer
    Community Power Platform Member Profile Picture
    on at
    Re: Error when importing data into entity

    Thank you all for helping! I tried to delete the whole environment (it was trial) which was the wrong move, because the environment I created after had disappeared from the list. Now I can't create a new one (says that I already have a trial environment) though the list of environments is empty. Working on the issue with the help from Power Platform Support. If the issue will be resolved I'm going to try to import excel data as you've written here before.

  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on at
    Re: Error when importing data into entity

    Hi @Anonymous, if your issue is still not resolve, I would suggest submitting a Microsoft Support ticket at:  https://admin.powerplatform.microsoft.com/support

  • v-siky-msft Profile Picture
    on at
    Re: Error when importing data into entity

    Hi @Anonymous ,

     

    Not sure what is happening on you, but here is alternative workaround from Dynamics (Reference from here) which seems to be more reliable and consistent.

    The Detailed steps.

    1. Go to solution explorer
    2. Remove everything after dynamics.com in the url and hit enter
    3. Go to Settings > Data management
       
       

      Dynamics.png

    4. Imports
    5. Choose EXCEL TEMPLATES> Create excel template
    6. Select template to create: Excel template (defaults to this)
      1. Select Data:
      2. Filter by entity: 
    7. Used saved view: Choose a view of the entity—do you know how to make views?: https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/dn509... (I can show you on a call if you’re interested.)
    8. Click download file
    9. Open the downloaded .xlsx file
    10. Populate the data into appropriate columns into the spreadsheet
    11. Save and close the spreadsheet
    12. Go back to the dynamics imports page and click IMPORT DATA
    13. Choose the spreadsheet
    14. Click next
    15. Choose whether or not to allow duplicates and select owner
    16. Click submit

    Hope this helps.

    Sik

  • Community Power Platform Member Profile Picture
    on at
    Re: Error when importing data into entity

    Also when importing the csv-file, the message is as following:

    powerapps_02.png

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.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics