cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Laney
Level: Powered On

PowerApps Error - GetData -> Get Data from Excel

Hi,

 

 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.

 

 

10 REPLIES 10
Community Support Team
Community Support Team

Re: PowerApps Error - GetData -> Get Data from Excel

Hi @Laney,

 

Please try to change another way to import the data:

  1. Next to New entity, click the ellipsis, and then click or tap Import data.
  2. Select the entity that you want to import data into, and then click or tap Next.
  3. Click or tap Search. Select the file that you want to import data from.
  4. If the Mapping Status is not Match with a green check mark, then you will need to specify the mapping between the entity fields and the columns in the Excel file. To map the columns:
    1. Click or tap Show Mapping.
    2. For each entity field, select the matching column in the Excel file.
    3. Click or tap Save changes.
  5. Click Import.

 

In addition, when I select the ellipsis beside the custom entity, it shows like below which is different from your screenshot:

Capture.PNG

 

Also, please try with other enities to have a test.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Laney
Level: Powered On

Re: PowerApps Error - GetData -> Get Data from Excel

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

 

 

 

 

PowerApps Staff CWesener
PowerApps Staff

Re: PowerApps Error - GetData -> Get Data from Excel

Adding @sabinn from the Data integration team.

Thanks,
Clay.

Re: PowerApps Error - GetData -> Get Data from Excel

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.

 

Powerapps Error.JPG

Felipe_ISSWorld
Level: Powered On

Re: PowerApps Error - GetData -> Get Data from Excel

HI,

 

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 🙂 

 

apps.PNG

 

 

 

Laney
Level: Powered On

Re: PowerApps Error - GetData -> Get Data from Excel

@Felipe_ISSWorld unfortunately No Smiley Sad. But i have not tried it again ever since..

BrianSlalom
Level: Powered On

Re: PowerApps Error - GetData -> Get Data from Excel

I am blocked by this exact issue. 

What is the workaround for this?

 

 

TScholl
Level: Powered On

Re: PowerApps Error - GetData -> Get Data from Excel

I got the same situation with a slightly different error message: 

 
The import service is not available: Connection set initialization failed for project DMImport_2018_11_07T09_55_27_335Z. Error: Service principal couldn't be written.
 
This error occurs on a development type environment. On a trial type and on production type it works fine.
Administrator
Administrator

Re: PowerApps Error - GetData -> Get Data from Excel

Please review the following thread that is marked a solution for importing excel data errors. 

 

https://powerusers.microsoft.com/t5/General-Discussion/Common-Data-Service-import-excel-error/m-p/81...

 

If this does not help please reply in the thread and we will continue to search for a solution. 

 

@TopShelf-MSFT

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 169 members 5,551 guests
Please welcome our newest community members: