Answered

Importing Excel data into Dataverse table

(0) Share

Report

Posted on by Bryan_Inglis

Hi, I am trying to import ~100k rows from an Excel table into a Dataverse table. If I use the 'Import data from Excel' and go through the motions, when I come to mapping the excel columns to the dataverse table, some of the dataverse columns and not offered to map to. If I just use the 'Import data' and go down that route, I select Excel, upload the excel file, transform any columns, map the columns and I'm then offered the 'Publish' option, which I choose, but then nothing seems to happen....Am I doing something wrong?, is there any way to confirm activity after pressing the Publish option??

Bryan

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @Bryan_Inglis, in your environment left panel under the Dataverse tab, select the Dataflows tab and check the status:

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Bryan_Inglis 6 on at

Like (0)

Report
Copy link

Link copied!

@AhmedSalih , thanks for that👍, at least now I can see where the progress is. Thats now showed me the error that I'm getting...
That makes no sense.....my only guess is that the incoming column names should have no spaces? - which I'm going to try now....🤞

Was this reply helpful? Yes No
Bryan_Inglis 6 on at

Like (0)

Report
Copy link

Link copied!

Yup, seems to have have been spaces, however, removed the spaces, tried again but NG. Eventually deleted each column title and retyrped and this worked fine. Another lesson learned on the road to Dataverse nirvana lol. Thanks.

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Copy link

Link copied!

@Bryan_Inglis thank so much for the update. I have a full tutorial for Excel to Dataverse migration that you may find useful : https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com