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?
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
thanks Erlandcrf.
I am using get data from Excel. half got loaded when I last checked. what could I do now?
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.
stampcoin
15
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1