Answered

Excel to New Dataverse Table - Only First 20 Rows

(1) Share

Report

Posted on by 07GT

Hello,

Has anyone else had the same issue? I tried creating a new Dataverse table from Excel data. The table has 313 rows which show they've all been loaded in the preview (see attached photo), and are ready to be created. When I press "Create" and look at the data, only the first 20 rows have been pulled into the new Dataverse table.

Am I missing a setting somewhere? Or is this a Microsoft issue?

Thanks,

Jason

Categories:

Microsoft Dataverse with Power Apps

I have the same question (4)

All responses (11)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @07GT ,

It just previews the first 20 records. Actually, there are already more than 300 records in the table.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,928 Moderator on at

Like (1)

Report
Copy link

Link copied!

@07GT

This is because it only tells you it did 20, if you walk away and leave it. Just forget it exists, it will complete them all.

20 is the known initial number in the docs it says its doing, but just let it finish as long as it takes and don't keep retrying etc or clicking create. You'll drive yourself insane.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
07GT 51 on at

Like (0)

Report
Copy link

Link copied!

Ok thank you! I didn't realize there would be a delay in upload time.

Jason

Was this reply helpful? Yes No
Diti 41 on at

Like (2)

Report
Copy link

Link copied!

how long is this delay for? it's been a number of days now and i still see 20 rows

Was this reply helpful? Yes No
MrGiant 24 on at

Like (2)

Report
Copy link

Link copied!

I have the exact same problem. Uploaded a file over a week ago and it's still only 20 rows

Was this reply helpful? Yes No
Tejaskumar 69 on at

Like (1)

Report
Copy link

Link copied!

Does anyone know why this delay? I'm stumbled upon the same and waiting now if it increases rows in the table or not. So far only 20 rows are visible.

Was this reply helpful? Yes No
hongkong 277 on at

Like (1)

Report
Copy link

Link copied!

Same problem here. I upload an excel with over 3000 rows but only the first 20 rows is created in dataverse.

Was this reply helpful? Yes No
MrGiant 24 on at

Like (1)

Report
Copy link

Link copied!

Unfortunately all I can import now is blank rows. To say my access to this is totally f**ked would be an understatement.

Was this reply helpful? Yes No
A-Dubs 2 on at

Like (1)

Report
Copy link

Link copied!

I've tried this waiting 10 hours for a 1700 row Sharepoint Online List and Excel Export of the same list. I only ever get the first 20 rows either way.

Was this reply helpful? Yes No
awilson1 2 on at

Like (1)

Report
Copy link

Link copied!

Having the same issue after a day of creating the table from an excel file. Any other info on this?

Was this reply helpful? Yes No