Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

The import service is not available: Connection set initialization failed for project ImportService



I have created a new entity on powerapps and was trying to import some data. Was getting the below error when i try to do so:



The import service is not available: Connection set initialization failed for project ImportService_2018_06_01T23_19_30_909Z. Error: Connection set name DM_CdsToFile_39220ffa48854fa083e83f4b92ae392f_Ammar is not valid. Verify that no non-word characters are in the connection set name.




Please advise,



Not applicable

And here I am, mid-April 2020 and STILL getting this error which appears to be so-egregious as to warrant an immediate fix. I mean, getting data into and out of Excel is one of the PRIMARY USE CASES of the POWER PLATFORM. innit?

My Federal Government client will be very interested in this boggling non-fix.

PS: It's NOT my browser, It's not my entity, it's the failed import service your end. Please pay attention to these posts.

New Member



I also have the same problem:


The import service is not available: Connection set initialization failed for project DMImport_2020_05_07T12_28_58_769Z. Error: Service principal couldn't be written


Has anyone gotten a reply on the solution yet? If not, how is everyone with this problem importing the data? Thanks!

Not applicable

It would appear we're speaking into the wind. No response is now the official response I suppose.

Sorry about this guys. Not sure how i missed the earlier posts. Allow us to look into this right away and get back to you with an update/fix.


Are you using the Community Plan? Unfortunately, our service does not support the Community plan.


It is really hard to get behind the Community Plan @sabinn when there are limitations like this, and there are other limitations. IMHO, the Community Plan needs to be like SQL Server Developer Edition. 100% functionality, just a limit on usage (connections, etc.)


Makes it impossible to test Power Apps solutions for clients with it broken like this.

Not applicable

I totally concur. As I mentioned, populating test/lab instance with Excel data is an essential use-case for my US Federal client. 
I totally understand the difference between test/lab evaluation instances and production instances. I'm not trying to 'steal' functionality via license exploitation. I simply need to see this Excel import capability working so that I don't have to fat-finger a hundred dang records to dozen different database/tables.  I appreciate Mr. @sabinn is now participating in this conversation. This issue has been hanging in this thread for way too long.  Perhaps we can get some relief. Otherwise I got bad-news for my Fed Client and I don't care to carry that kind of mail... it's career-limiting. 

Regular Visitor

Community plan needs to support import/export to Excel. The number of rows can be limited to a reasonable number like 100.

Frequent Visitor

I didnt know this is going on so long. I agree with the previous posts that If you wanna trial something, just let us try and not let us bumping into a lot of issues like this with all the trial limitations. We see a great potential in this whole power apps/portal, but asfar we know now I am not going to present this to my management. @sabinn 

So please use a more readable error, something saying that this outside your plan or disabling the buttons, but this is really annoying, I had to search in the internet to know what I was doing wrong.

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (1,213)