Not able to import animal excel data to dataverse.

[vandan230997]

Please help me resolve the issue.

[SandyG]

@vandan230997 In the lesson, the instructor said to click "map columns", choose the correct columns to map.  

[VaishaliMalode]

I have same query please help me, Not able to fetch the Animal table in dataverse

[bleepnik]

Yesterday during the Q&A live session, our host Ahmed shared a resource with us which may help:

https://ahmedsalih.blog/blog/f/excel-to-dataverse-migration---part-1

[MorganG]

I looked at the resource you shared here, and it is not helpful for solving the issue with loading data from the Animals table. I saved the excel file as a csv, made all the same columns, created the form and views to ensure all columns would be included, and yet when I upload the data and map all the columns only the Name populates. 

[BCBuizer]

Hi @MorganG , @vandan230997 ,

Please check this post with multiple possible issues and solutions that you may encounter when importing data from CSV: Solved: Re: Issue with Importing CSV file - 3 rows missing - Power Platform Community (microsoft.com...

In case this does not resolve the issue for you, please share some details of how you are trying to import and the outcome. This context is key in figuring out how to resolve the issue for you as there are many variables involved in the process.

[MorganG]

I figured out a solution for my particular problem. It was the MicrochipID number - some of the values were higher than the upper limit that the platform could handle. I tried to adjust the upper limit, but wasn't able to. So I had to delete a number off the IDs that didn't load. 

[vandan230997]

I converted the excel data to table and it worked for me.

[iddymichs]

Did you convert it to table in Excel before importing cos Im having the same issue.