cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lalder
Level: Powered On

Importing Data from Excel

I'm trying to use the import tool to import an Excel spreadsheet, but I'm getting the attached error.

 

My spreadsheet is about 500,000 records. Can anybody tell me how to resolve the error? Is there a better way to import the data?
 
Thanks
6 REPLIES 6
Power Apps Staff CWesener
Power Apps Staff

Re: Importing Data from Excel

 

Hi @lalder - thanks for posting. Can you tell me what tool you're using to import your Excel spreadsheet? If you can give me a screen shot and describe the menu path you're using it will help.

 

Thanks,

Clay.

Thanks,
Clay.
lalder
Level: Powered On

Re: Importing Data from Excel

@CWesener I'm using the import button shown below. Thanks!

 

 

Capture.JPG

Power Apps Staff CWesener
Power Apps Staff

Re: Importing Data from Excel

 

Thanks! Adding @sabinn from the Data integration team.

Thanks,
Clay.
Microsoft sabinn
Microsoft

Re: Importing Data from Excel

Can you try chunking/staggering - Try 5k records.

If that works, you most likely its not an issue with the type/shape of source data and try going up do 10k chunks and then 20k.

500k at one-shot could be the issue unless there are other issues with source data.

BTW, you should see errors under 'notifications' (left hand pane). You want to report those as well. 

sabinn
lalder
Level: Powered On

Re: Importing Data from Excel

@sabinn Thanks, I'll give that a try and report back.

lalder
Level: Powered On

Re: Importing Data from Excel

For anybody that may be reading this in the future- I neer did find a solution to my issue. I ended up switching to a SQL server instead.

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Users online (9,762)