Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 711 Most Valuable Professional
Michael E. Gernaey 319 Super User 2025 Season 2
Power Platform 1919 268