Announcements
I created CDS table and now I am trying to populate it from Excel sheet. I am getting above error after a long while seeing importing message. what I could be missing? I do not have any unique column, so I created serial numbers in Excel and I am mapping name to that column in excel.
is there log or something? how to resolve this?
Hello @Anonymous
This seems to be quite a common scenario, however, the causes could be different depending on the actions that you are trying to do, so, how exactly are you trying to import this data into the CDS? Are you using the Import "Get Data from Excel" or "PowerQuery" for that?
I found another reference from the communities where there are other users that faced similar issues and their resolution, I hope that it can be helpful for you as well: https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Failure-when-importing-data-to-entity-using-Get-Data-from-Excel/td-p/239613
Thanks.
thanks Erlandcrf.
I am using get data from Excel. half got loaded when I last checked. what could I do now?
Hi @Anonymous,
Since "Get Data from Excel" actually generates a Dataflow, to see more details on the error, in make.powerapps.com, go to:
Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 326 Most Valuable Professional
11manish 168
sannavajjala87 75 Super User 2026 Season 1