Answered

Dataverse won't import all the rows | Import a large csv to an existing Dataverse table

(0) Share

Report

Posted on by defr4055

Hi All,

Reaching out to see if anyone has a solution to an import issue I'm experiencing. I'm attempting to import a csv file to an existing table in the Dataverse. The file has about 100-200 columns, and over 6000 rows. When I import it to my existing table it only loads about 200 of those rows. I'm not getting any type of error, but the data just isn't loading. Has anyone experienced this issue and/or know the solution? I have tried to also export the table first, then copy the data to the exported file, and then re-import the file but no luck. I'm using the table in a model driven app, but the issue lies in the Dataverse (I believe). Any help is appreciated.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

365-Assist 2,324 Moderator on at

Like (0)

Report

What method are you using to import the file? Can you please include a screen shot.

Was this reply helpful? Yes No
defr4055 28 on at

Like (0)

Report

Just the standard import. When I connect to a data source, I've tried both methods of "link a file" and "Upload file (preview)". See screen shots below

Was this reply helpful? Yes No
Verified answer

365-Assist 2,324 Moderator on at

Like (0)

Report

One work around would be to create a Power Automate Flow that adds Rows to the table from the CSV.
That way you can get some good visibility into any issues.
--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
Verified answer

defr4055 28 on at

Like (1)

Report

Hello,

Thanks for the assist. I learned through trial and error that I should be uploading on Microsoft edge rather then google chrome.

Was this reply helpful? Yes No