Announcements
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
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
you mean to map my index column in excel to primary id in 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/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
Yes.
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
Thanks man, great method
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
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
