I want to import data into a custom entity created in CDS PowerApps from an Excel file. (look at attachment)
However as soon as i click on Get Data from Excel, i get the following error.
The import service is not available: Connection set initialization failed for project DMImport_2018_06_14T06_09_44_117Z. Error: Connection set name DM_CdsToFile_d8d59e7689074138a9ba34c57e1f40f7_EeLane Yu is not valid. Verify that no non-word characters are in the connection set name.
Please try to change another way to import the data:
In addition, when I select the ellipsis beside the custom entity, it shows like below which is different from your screenshot:
Also, please try with other enities to have a test.
Thanks for the response.
I tried accessing it from the ellipsis (...) of other entities and also a different environment but I still see smiliar options and encounter the same error
I'm getting the same issue, I have " (ALN)" at the end of my user name, my co worker does not so he can do it!.
Also having issues when trying to connect using the other data methods, such as CSV. That too gives a credentials error.
I have the same issue when trying to get data from excel in a test environment.
The weird thing is that Im able to get the data when I try from my default environment.
Have you found a solution for this?
Thank you 🙂
I got the same situation with a slightly different error message:
Please review the following thread that is marked a solution for importing excel data errors.
If this does not help please reply in the thread and we will continue to search for a solution.