I need to import 90K records to a custom entity, I've tried all alternatives to do it (Excel, CSV, Sharepoint list, Web page) but once I start the data integration project it always get stuck on "Creating definition group in CDS".
I also tested with different file sizes (150 records), different field order> Same results
Any ideas how to solve this?
Hi @bbtestA0 ,
Do you want to import data into your CDS Entity using Data Interation Project in your PowerApps?
Have you taken a try with the "Open in Excel" option within your target Entity?
I have made a test on my side, and don't have the issue that you mentioned.
The user @BrianSlalom has faced similar issue with you, please check the response within the following thread:
You could also consider take a try with the "Open in Excel" option within your target Entity, and then import your records into the opend Excel file, click "Publish" button to save your records into your target Entity.
More details about importing data into CDS Entity using "Open in Excel" option in a Entity, please check the following article or blog:
In addition, you could also consider take a try with the alternative solution mentioned within the following thread (instead of your Data Integration project😞
check if the issue is solved.
Also please take a try to re-create new Data Integration project within your app, try the "Import" functionality again, check if the issue still exists.
With few records, Excel Add-in is a possibility but I need to upload 90,000 records. I've tried every possible alternative with no results and finally I posted my case to MS support.
They are aware of the case but haven't sent me an answer
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021