Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Stuck on "Creating definition group in CDS"

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?

Community Support
Community Support

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.


Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @bbtestA0 ,

Same here, stuck at creating definition group.  Other options are quite cumbersome.  This should be fixed!

Hi @v-xida-msft 


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





No, still waiting for a response from MS Support

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Kudoed Authors
Users online (86,648)