import from excel into dataverse

(0) Share

Report

Posted on by chahineatallah1

249

Hello

Trying to import from excel into an existing dataverse table, it doesnt show any error, and everything is ok, but the data doesnt get uploaded into dataverse

But if i choose to import into new table, it does import why is that?

video showing whats happening

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

calerof 255 on at

Like (1)

Report

Re: import from excel into dataverse

Hi @chahineatallah1,
Add an index column to your Excel data in the transformation stage in Power Query and use it to map to the ID field.
Cheers,
Fernando

Was this reply helpful? Yes No
chahineatallah1 249 on at

Like (0)

Report

Re: import from excel into dataverse

you mean to map my index column in excel to primary id in dataverse?

Was this reply helpful? Yes No
Ram Prakash 5,576 Super User 2025 Season 2 on at

Like (1)

Report

Re: import from excel into dataverse

Hi @chahineatallah1

Request you to have a look on my Blog. This will help you the same.

https://microsoftcrmtechie.blogspot.com/2023/06/how-to-create-record-in-dataverse-excel.html

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
calerof 255 on at

Like (1)

Report

Re: import from excel into dataverse

Yes.

Was this reply helpful? Yes No
chahineatallah1 249 on at

Like (0)

Report

Re: import from excel into dataverse

Unfortunately, it also didnt work, what i ended up doing, is edit my dataverse table in excel, just copy pasted all columns, it worked, i think the issue is in my primary column as my primary column is a description which might not be unique
any ways thanks

Was this reply helpful? Yes No
chahineatallah1 249 on at

Like (0)

Report

Re: import from excel into dataverse

Thanks man, great method

Was this reply helpful? Yes No
chahineatallah1 249 on at

Like (1)

Report

Re: import from excel into dataverse

so we found a solution with the help of one member of power community ,super user @AhmedSalih (who advised what the issue is)
and the solution was pretty easy, just remove the spaces/trailing space in the column headers in my excel file , and the excel file was imported to dataverse, in addition if you have any choice columns, make sure your data in excel matches the choices data (specially the cases for example if you have "pending" as choice make sure it is "pending" in excel and not "Pending" to avoid errors also)

How this issue was detected? in dataflows section it actually shows why the data was not published

Was this reply helpful? Yes No